Excel extraction
Closed
jenel
-
Apr 9, 2009 at 03:14 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Apr 10, 2009 at 04:36 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 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
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:
- Excel extraction
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Apr 10, 2009 at 04:36 PM
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
Maybe you could try this : http://office.microsoft.com/en-gb/excel/HP052510211033.aspx#SplitCellContents
Best regards