put everything after comma, into next column?

[_Bigred]

I have a column that contains the following style of data:

Smith, John
Smith,John
Smith,John (WCCS)
Smith, John (WCCS)

I would like to eliminate the "," and place the text after the "," into the
next column.

How can I do this?

TIA,
_Bigred

 

[Norman Harker]

Hi _Bigred!

Use Data > Text to Columns

You have a delimited list with comma separator.

 

[Alan]

You can use Data > Text to Columns
Select the column with your data
Choose 'Delimited' > Next
Check 'Comma' > Next
If the result looks OK, Finish
Note that there is a space in your first and last examples, but not in the
others which could cause problems if you want to use VLOOKUP, COUNTIF etc
If this is the case you could use the TRIM function to eliminate the spaces,
Regards,

 

[_Bigred]

worked like a charm.

 

[David McRitchie]

Hi Alan,
It is possible to eliminate the extra space after the comma
strictly with Text to Columns. Personally I would use my TrimALL
macro since I have it set up .
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Data, Text to Columns, comma delimiter
as already described to separate into the two columns
(dependent on there being only one comma in the cell)

Data, Text to Columns, fixed width
double click or drag the break line off the window to remove
with only one column then finish

You can use Data > Text to Columns
Select the column with your data
Choose 'Delimited' > Next
Check 'Comma' > Next
If the result looks OK, Finish
Note that there is a space in your first and last examples, but not in the
others which could cause problems if you want to use VLOOKUP, COUNTIF etc
If this is the case you could use the TRIM function to eliminate the spaces,
Regards,