Changing Text

[fearll]

I am doing a spreadsheet where the data was pulled with the athlete'
last name first and then a comma and then the first name (e.g ALLEM
FULTON AUTO PHOTO) I would like to change it to read (e.g. FULTON
ALLEM AUTO PHOTO) Is there a way to change multiple cells at the sam
time that read the same way but with different athletes?

 

[jeff]

Try
=RIGHT(A1,LEN(A1)-FIND(", ",A1,1)-1) & " " & LEFT
(A1,FIND(",",A1,1)-1)

jeff

 

[Guest]

There has to be an easier way but this will work, assuming A1 = ALLEM, FULTON AUTO PHOT

=CONCATENATE(MID(A1,FIND(", ",A1)+2,(FIND("AUTO PHOTO",A1)-2-FIND(", ",A1)))," ",LEFT(A1,FIND(", ",A1)-1)," ",RIGHT(A1,10)

----- fearll > wrote: ----

I am doing a spreadsheet where the data was pulled with the athlete'
last name first and then a comma and then the first name (e.g ALLEM
FULTON AUTO PHOTO) I would like to change it to read (e.g. FULTON
ALLEM AUTO PHOTO) Is there a way to change multiple cells at the sam
time that read the same way but with different athletes?

 

[Gord Dibben]

Fulton Allem is not an athlete......he is a Golfer.

Gord