Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One field into many fields ?
I have a large sheet with over 15,000 lines, one for each customer.
Problem is that one column includes: B1 FirstName LastName NNNN Any St Suite NNN City STATE ZIP Can someone explain to me in details how to - I think the word is - PARSE - this field to separate the data over several columns ? B2 FirstName B3 LastName B4 Address Line 1 B5 Address Line 2 B6 City B7 State and so on. Many thanks. Denis |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One field into many fields ?
Take a look at Text to columns in dsata menu and delimit by space
"MiataRed" wrote in message oups.com... I have a large sheet with over 15,000 lines, one for each customer. Problem is that one column includes: B1 FirstName LastName NNNN Any St Suite NNN City STATE ZIP Can someone explain to me in details how to - I think the word is - PARSE - this field to separate the data over several columns ? B2 FirstName B3 LastName B4 Address Line 1 B5 Address Line 2 B6 City B7 State and so on. Many thanks. Denis |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One field into many fields ?
Your example shows the data to be split out into only one column B2, B3, B4 etc.
I believe you want it across columns like B2, C2, D2, E2 etc. Try DataText to columnsDelimited by Space. May not be perfect, but close. Gord Dibben MS Excel MVP On 21 Jun 2006 11:05:10 -0700, "MiataRed" wrote: I have a large sheet with over 15,000 lines, one for each customer. Problem is that one column includes: B1 FirstName LastName NNNN Any St Suite NNN City STATE ZIP Can someone explain to me in details how to - I think the word is - PARSE - this field to separate the data over several columns ? B2 FirstName B3 LastName B4 Address Line 1 B5 Address Line 2 B6 City B7 State and so on. Many thanks. Denis |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One field into many fields ?
Right you are - I need them on a single row, not column... Thanks.
Will try it. Denis Gord Dibben wrote: Your example shows the data to be split out into only one column B2, B3, B4 etc. I believe you want it across columns like B2, C2, D2, E2 etc. Try DataText to columnsDelimited by Space. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One field into many fields ?
'Data'....'text to columns'
When you are doing this take note of what each step does even if you are just clicking on 'next' as it may help you formatting the cells as text or numbers etc. "MiataRed" wrote: I have a large sheet with over 15,000 lines, one for each customer. Problem is that one column includes: B1 FirstName LastName NNNN Any St Suite NNN City STATE ZIP Can someone explain to me in details how to - I think the word is - PARSE - this field to separate the data over several columns ? B2 FirstName B3 LastName B4 Address Line 1 B5 Address Line 2 B6 City B7 State and so on. Many thanks. Denis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
pivot field of fields | Excel Worksheet Functions | |||
How to combine dat from 4 fields into one field | Excel Worksheet Functions | |||
Extract Portion of field into other fields | Excel Worksheet Functions |