Split a column value into two columns

Hi all! I have a column name Name. What I'm trying to do is separete the concatenated field into two diff. fields (LastName and FirstName).

Example: Doe, Jane

I would like to leave Doe in the current column and place Jane in a new column to the left of that column.

Hope that makes sense.

All help is appreciated!

TRJ

Use Data | Text to Columns, with a comma defined as the delimiter.

Hope this helps.

Pete

Thanks, Pete!

This method appears to do the job, but will leave a leading space in front
of Jane, unless both "space" and "comma" are used as delimiters.....

Vaya con Dios,
Chuck, CABGx3


"Pete_UK" <[email protected]> wrote in message
news:[email protected]...
> Use Data | Text to Columns, with a comma defined as the delimiter.
>
> Hope this helps.
>
> Pete
>

Keeping within your two columns.....assuming Doe, Jane is in B1......
In A1 put this and copy down....
=MID(B1,FIND(",",B1,1)+2,99)
Then do Copy > PasteSpecial > values on column A
Then highlight column B and do Edit > Replace > FindWhat: ,* > ReplaceWith:
leave empty > ReplaceAll

Vaya con Dios,
Chuck, CABGx3


"trjdba" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all! I have a column name Name. What I'm trying to do is separete
> the concatenated field into two diff. fields (LastName and FirstName).
>
>
> Example: Doe, Jane
>
> I would like to leave Doe in the current column and place Jane in a new
> column to the left of that column.
>
> Hope that makes sense.
>
> All help is appreciated!
>
> TRJ
>
>
> --
> trjdba
> ------------------------------------------------------------------------
> trjdba's Profile:
http://www.excelforum.com/member.php...o&userid=14989
> View this thread: http://www.excelforum.com/showthread...hreadid=504072
>