Seperating of Text in one cell into two columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It's been a while... how do I seperate text in one cell into two cells
effectively two columns.

Example

A1 (Column & Row) Last Name, First Name needs to be seperated into
(A1) Last Name (A2) First Name
 
Data> Text To columns, separator of comma.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top