excel question: (1 Viewer)

[cubd8]

I'm sure this is simple, but haven't done this in awhile and can use a little assistance.

thanks in advance!!!

Contents of b13:

[SIZE=10pt]string(16) bsrAccountNo;[/SIZE]

[SIZE=10pt]string(25) lastName;[/SIZE]

[SIZE=10pt]i want to create two cells, one with the string information and other with the field name; 2 separate cells:[/SIZE]

New Cells contain:

Put into C13....

string(16)

string(25)

Put into D13...

[SIZE=10pt]bsrAccountNo;[/SIZE]

[SIZE=10pt]lastname;[/SIZE]

 

[hagmania]

Highlight column B

Top Ribbon: Data

Text to Columns

Delimited

Space - make sure it's checked.