Hi,

With your string in A1

First part
=LEFT(A1,FIND(",",A1)-1)

Second part
=LEFT(A1,FIND(",",A1)-1)

Mike

"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