how remove all text to right of a comma

  • Thread starter Thread starter codonboy
  • Start date Start date
C

codonboy

Perhaps someone can help. I have a column where each cell holds text for
"last name, first name. For example: "Smith, Alice"

I need to remove "Alice" and put it into a column (same row) next to
the column that previously held "Smith, Alice".

I also need to remove the "," from what is now "Smith,".

Any ideas?

Thanks,

Gene



------------------------------------------------




------------------------------------------------
 
Select the range you want to separate . Then select "Text to Columns"
from Data Option, than select Fixed width, move the arrow to the
desired location................click on ok

regards
Imran



------------------------------------------------




------------------------------------------------
 
Alan, imran,

-- thanks guys. way easy!!

gene



------------------------------------------------




------------------------------------------------
 
Back
Top