You could do Data TextToColumns using SPACE as the delimiter to separate
each word into it's own separate column..........then CONCATENATE them back
together into the strings as you wish..........

Vaya con Dios,
Chuck, CABGx3



"cagolden2003" wrote:

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"....