Changing Text

  • Thread starter Thread starter fearll
  • Start date Start date
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?
 
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?
 
Back
Top