| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text string inverting
I am importing text, and it comes in reading from right to left.
How can I change it to read from left to right? I know that the formula below will invert two words, but how do you do more than two words? =RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1) Let's say I wanted "Right To Left" to read "Left To Right" or "John J Doe" to read "Doe J John".... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string and sum | Excel Worksheet Functions | |||
| Remove last character of text string | Excel Worksheet Functions | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| Extracting from a text string | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Threaded Mode
