Hi All!
I have a spreadsheet (Excel 2016 on Win 10) where certaincells in a column have multiple values entered using the Alt+Enter keycombination in a single wrapped cell. Ineed to extract those values and create separate cells for furtherprocessing. In a nutshell:
“J26” = 12
20
6
7
Needs to become:
“J26” = 12
“J27” = 20
“J28” = 6
“J29” = 7
With the original “J26” deletedand all other cells moved up/down as needed to preserve the data. I have tried recording a macro but all itshows is the end result being entered into the cells as a formula – does notshow what was removed to get there. Ihave searched for many hours but still do not have enough information to evenattempt writing the code.
Thank you so much for any assistanceand expertise!
I have a spreadsheet (Excel 2016 on Win 10) where certaincells in a column have multiple values entered using the Alt+Enter keycombination in a single wrapped cell. Ineed to extract those values and create separate cells for furtherprocessing. In a nutshell:
“J26” = 12
20
6
7
Needs to become:
“J26” = 12
“J27” = 20
“J28” = 6
“J29” = 7
With the original “J26” deletedand all other cells moved up/down as needed to preserve the data. I have tried recording a macro but all itshows is the end result being entered into the cells as a formula – does notshow what was removed to get there. Ihave searched for many hours but still do not have enough information to evenattempt writing the code.
Thank you so much for any assistanceand expertise!