Prev: How do I get a cell to auto change red when a certain numbe is ent
Next: Fill a 15 Characters Data with Zeros
From: Kitty on 24 Feb 2010 20:36
I have a list like this in column A:

cell A1. CHHKSHANAN000021,CHHKSHASAV001873,CHHKSHAOCF000026
cell A2. APLU020852965,APLU020852976,APLU020852966,APLU020852977


....but much longer. I want the data in separate cell (i.e., a1, a2, a3):

CHHKSHANAN000021
CHHKSHASAV001873
CHHKSHAOCF000026

I had tried the convert text to column wizard, however the data display only
horizontally. Is there a formula I can use to undo the Concatenated cells at
the same time insert the line to post each item?

Please help!

--
Thank you,


 | 
Pages: 1
Prev: How do I get a cell to auto change red when a certain numbe is ent
Next: Fill a 15 Characters Data with Zeros