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

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

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

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.

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