Thread: 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 template@discussions.microsoft.com> wrote in
message news:73DAB7A5-9C22-4DB5-AD0F-C5D5D1855AFB@microsoft.com...
> 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