Previous Topic Next Topic

Excel extraction

Closed
jenel - Apr 9, 2009 at 03:14 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Apr 10, 2009 at 04:36 PM
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
Related:

1 response

Answer 1 / 1
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Apr 10, 2009 at 04:36 PM
Hi,
Maybe you could try this : http://office.microsoft.com/en-gb/excel/HP052510211033.aspx#SplitCellContents
Best regards
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response