Split Data in One Column Into Two
 

Hello,

We have data that is last name first separated by a comma so it looks like
this: "Schmoe, Joe". What we would like to do is take the first name
(currently in column A) and move it over to column B while leaving the last
name in Column A.

Any easy ways to do this without manually going through thousands of records?

Split Data in One Column Into Two
 

Click DATA on the menu and select TEXT TO COLUMNS. In the next dialog box
indicate that the file type is delimited (default) and click the NEXT command
button. Click the COMMA checkbox and click the FINISH command button to
complete the process.

The data will be parsed into 2 columns and the trailing comma is
automatically removed.
--
Kevin Backmann


"RoadKill" wrote:

Hello,

We have data that is last name first separated by a comma so it looks like
this: "Schmoe, Joe". What we would like to do is take the first name
(currently in column A) and move it over to column B while leaving the last
name in Column A.

Any easy ways to do this without manually going through thousands of records?

Split Data in One Column Into Two
 

Smashing

"Kevin B" wrote:

Click DATA on the menu and select TEXT TO COLUMNS. In the next dialog box
indicate that the file type is delimited (default) and click the NEXT command
button. Click the COMMA checkbox and click the FINISH command button to
complete the process.

The data will be parsed into 2 columns and the trailing comma is
automatically removed.
--
Kevin Backmann


"RoadKill" wrote:

Hello,

We have data that is last name first separated by a comma so it looks like
this: "Schmoe, Joe". What we would like to do is take the first name
(currently in column A) and move it over to column B while leaving the last
name in Column A.

Any easy ways to do this without manually going through thousands of records?