Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate first name and page numbers
I have an excel file with the name and page number(s) in one column. I have
already separated the last name as there is a comma (usually). And I have separated the first name into it's own column, but this contains the page number(s) as well. Can someone provide a way for me to separate the first name (which may contain a middle name or initial and/or title) and the page number(s)? Here are some examples in my file: S. J. 45, 46, 59, 71, 138, 139 S. J., Mrs. 138 Samuel J. 51 Sally 3 W. 41 Warren 17, 61, 71, 95, 109 I want to end up with the page number(s) in one column and the entire first name in another column. thanks in advance if you can help! Sherry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate first name and page numbers
Select the data which is there in the column.
and use text to column option which is there in Data menu. I hope it may help you. Regards Heera |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate first name and page numbers
Thank you Heera. I tried that and don't know how to make that work.
"Heera" wrote: Select the data which is there in the column. and use text to column option which is there in Data menu. I hope it may help you. Regards Heera |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I print each row on a separate page? | Excel Discussion (Misc queries) | |||
Arggh! Each row prints on separate page | Excel Discussion (Misc queries) | |||
How do I save a page in a workbook as a separate file? | Excel Worksheet Functions | |||
print multiple, separate rows on each page | Excel Discussion (Misc queries) | |||
How can I separate rows to the bottom of the page with missing inf | Excel Discussion (Misc queries) |