One field into many fields ?

[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

 

[N Harkawat]

Take a look at Text to columns in dsata menu and delimit by space

 

[Gord Dibben]

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

 

[MiataRed]

Right you are - I need them on a single row, not column... Thanks.

Will try it.

Denis

 

[Guest]

'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.