undo concatenated cells
 

I have a list like this in column A:

cell A1. CHHKSHANAN000021,CHHKSHASAV001873,CHHKSHAOCF000026
cell A2. APLU020852965,APLU020852976,APLU020852966,APLU0208 52977

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,

undo concatenated cells
 

Kitty -

Try this:
1.) Do the text to column as you did before
2.) Select the Rows (in this case rows 1 & 2)
3.) Copy the entire row (Ctrl +C)
4.) Select the next empty cell (A3)
5.) Right click -- choose Paste Special... -- Check the Transpose box --
Click OK

You should achieve the results:

CHHKSHANAN000021 APLU020852965
CHHKSHASAV001873 APLU020852976
CHHKSHAOCF000026 APLU020852966
APLU020852977

"Kitty" wrote:

I have a list like this in column A:

cell A1. CHHKSHANAN000021,CHHKSHASAV001873,CHHKSHAOCF000026
cell A2. APLU020852965,APLU020852976,APLU020852966,APLU0208 52977

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,