Seperating of Text in one cell into two columns

M

Mistys template

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
 
B

Bob Phillips

Data> Text To columns, separator of comma.

--

HTH

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