Help Me Please -
 

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

Help Me Please -
 

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

Help Me Please -
 

I really meant

=TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)))

For the second part

Mike

"Mike H" wrote:

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

Help Me Please -
 

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

Help Me Please -
 

As long as there are 2 words separated by a comma you can use

=TRIM(MID(A1,FIND(",",A1)+1,255))&" "&TRIM(LEFT(A1,FIND(",",A1)-1))


Adjust to fit your cell ranges and copy down, then copy and paste special as
values either over the old values or better in place and make sure
everything went OK


--


Regards,


Peo Sjoblom

"Yossy" wrote in message
...
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

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

Help Me Please -
 

Give this a try...

=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)-1)

Rick


"Yossy" wrote in message
...
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