One field into many fields ?

  • Thread starter Thread starter MiataRed
  • Start date Start date
M

MiataRed

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
 
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 Data>Text to columns>Delimited by Space.

May not be perfect, but close.


Gord Dibben MS Excel MVP
 
'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.
 
Back
Top