Changing Text

F

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?
 
J

Jonathan Cooper

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?
 
Top