| 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 |
| 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 | |||
Threaded Mode
