undo concatenated cells

K

Kitty

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
 
M

Matt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top