Excel extraction [Closed]

Report
-
Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
-
Hello,
I'd like to be able to extract all the data which comes after the comma from a cell in each row and insert it into a new column.

Here's an example of the cell data:

Bakke, Blondina 1910-1975

Formula?

Thanks!

--jenel

1 reply

Posts
7083
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 25, 2020
476
Hi,
Maybe you could try this : http://office.microsoft.com/en-gb/excel/HP052510211033.aspx#SplitCellContents
Best regards

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!