How to reverse text in Google Sheets?
Leonardo da Vinci wrote in reverse because he was left-handed, and regular writing would smear the text in his notebooks.
Did you copy text from a specific source to Google Sheets, and the text reversed? This mainly happens in Hebrew.
Single words? Entire sentences? While there are websites that can reverse text, if you have many cells, the following formula can work its magic of text reversal:
=ArrayFormula(CONCATENATE(MID(A2,SEQUENCE(LEN(A2),1,LEN(A2),-1),1)))
How to reverse text in Google Sheets?
Leonardo da Vinci wrote in reverse because he was left-handed, and regular writing would smear the text in his notebooks.
Did you copy text from a specific source to Google Sheets, and the text reversed? This mainly happens in Hebrew.
Single words? Entire sentences? While there are websites that can reverse text, if you have many cells, the following formula can work its magic of text reversal:
=ArrayFormula(CONCATENATE(MID(A2,SEQUENCE(LEN(A2),1,LEN(A2),-1),1)))
The essence of this formula is built on the MID function, which extracts characters from a string. The function takes a start number and the number of characters it should return.
Instead of specifying a single number, we use the SEQUENCE function, which returns a different position in the string each time. For example, in the word "philosophy," the last letter is at position 9, the one before it at position 8, and so on.
We instruct the function to start from the last character using the LEN function, which returns the number of characters in the string. Then, by using "1-" in the function, it reverses the order of characters.
The formula breaks down the characters in reverse order. All that's left is to concatenate them using CONCATENATE. Since Google Sheets doesn't yet handle arrays like the latest version of Excel, we wrap it all in ARRAYFORMULA.
Good luck!
Comments