Parsing

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
Highlight A1:A7, At the Menu, select Data, Text to Columns... Ck Delimited
(next);
then Ck both Comma and Spaces; then Finish.
 
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
 
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
 
Back
Top