Seperating of Text in one cell into two columns
 

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)


"Mistys template" <Mistys wrote in
message ...
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