Reverse Text (String) Formula - Google Sheets & Excel, no VBA or JavaScripts

preview_player
Показать описание
Learn how to reverse text (string) with a formula in Google Sheets & Excel. We will not be using VBA or JavaScripts, jut worksheet formulas to reverse values.

#reverse #string #formula
Рекомендации по теме
Комментарии
Автор

Teacher...I like the way you solved a problem with a Simple Example and then grew the Formula into one that fulfills all your needs to get the job done!!!

cheewurz
Автор

Teacher...I just LOVE your Videos on how to make Dynamic Formulas!!!

Electric-Bob
Автор

Always fascinating thank you. I love your ingenuity!

garychadwick
Автор

It was a great exercise for my brain this time. Thank you! :-)

takaakiyamada
Автор

Amazing!! I’m trying to figure out where on earth will I be ever using this feature? If Florida Oranges can be converted to Oranges Florida may be I can think of a usage, like say first name and last name swapping around, but Reverse Text, no I can’t think of a need, unless I’m missing something.

rajeshr
Автор

I have office 2013. There is no sequence function in exce 2013. How do I achieve this using formula?

techgalaxy
Автор

Hey man, I'd appreciate it if you could find a way to reverse the =formulatext function.
I did my research on YT and Google and could only find the =indirect function, , but I need something that would work with =sum(A1:G8) for example.
So to recap the question: Imagine you used =formulatext on a cell containing the formula =sum(A1:G8), how do you convert it from text to a formula again?

RadoHudran
Автор

Not that I need a string backwards, but revised it does help me in other situations!

marcpennings
Автор

Teacher...The Mid Function in Google Sheets doesn't seem to allow a Range of Cells for the Starting Point as it does in your Excell Example...yes...no!?

Electric-Bob
Автор

This is pretty helpfull. You just forgot to edit the formula in google sheet arrayformula (i. e. A1 to A1:A) so that you don't have to drag the formula down. 😊

michaelborja
Автор

sir I used Filter script as per your video (it was made an year ago) but out of the filtered result, I only want to display one column, I am stuck out there

gsxmentor
visit shbcf.ru