Help Me Please -
Thanks a big bunch, it works
"John C" wrote:
Assuming column A has your data, and assuming ALL data is in the format of
"word, word" (comma and space separator, and only 1 comma in each data item).
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)
--
John C
"Yossy" wrote:
Please I need help with this. I have series of values like this -- Animals,
Domestic. How do I change them all to be like this Domestic Animals. Thus, I
want to remove all commas and swap the first word to the last.
The above is an example. I have multiples of various information like this.
All help totally appreciated.
Thanks
|