Parsing

[lehigh]

Hi All:

In column A, I have text as shown below

A, B, C1, D
A, G, G1
S, S1
H, J, S1, S2
B
M
M, M1

Each code is seperated by a comma and a space
Some codes have one charactor, some have two

I would like to write formulas in columns C, D, E, & F that would
parse out these codes.

If all were single charactors or all were two charactors, I would have
no problem.


Thanks for any help you can give me.

Tom Snyder

 

[JMay]

Highlight A1:A7, At the Menu, select Data, Text to Columns... Ck Delimited
(next);
then Ck both Comma and Spaces; then Finish.

 

[Bernard V Liengme]

Hi Tom,
Select the column of data and use Data|Text to Column
You must be an old Lotus practitioner to use the phase 'parsing'
Bernard

 

[RagDyer]

Try:
Select your data,
<Data> <Text To Columns>,
Check "Delimited", Click <Next>,
Check "Comma", Click <Next>,
Click <Finish>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi All:

In column A, I have text as shown below

A, B, C1, D
A, G, G1
S, S1
H, J, S1, S2
B
M
M, M1

Each code is seperated by a comma and a space
Some codes have one charactor, some have two

I would like to write formulas in columns C, D, E, & F that would
parse out these codes.

If all were single charactors or all were two charactors, I would have
no problem.


Thanks for any help you can give me.

Tom Snyder