undo concatenated cells

  • Thread starter Thread starter Kitty
  • Start date Start date
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
 
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
 
Back
Top