function to split column data

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

How can I do a function to separate a column so that if A1
contains "Billy Bob", in B1 I would get "Bob, Billy".

Can that be done?

Thanks in advance
Jose
 
Hi Jose!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top