Hi,
Anyone have an idea how to unwrap from a multiple wrapped text cells into multiple single cell?
Example: to convert the data wrapped text in cell A2 to J6 into single line from A8 to A11. How to do it?
attached file.
Thank you,
CY
Manually this can be done by
1) Unmerging cells
2) Text to columns with only the other delimited box selected and do ctrl+j (line break)
3) as the data is now in columns, select the resulting cells, copy
4) click in a8 paste>special>transpose
VBA would ultimately do the same thing if it was a repetitive task
Purfleet
Thank you Purfleet. I was using the same way as you mentioned. Thought that can have any other faster way to do it. 🙂 I have a long list to split that. 🙁
Thank you for sharing.
At least we both did it the same way!
if you had to do this regularly, say daily or weekly, they i would say a macro is the best way to do it or if you had multiple cells with maybe 5 lines in each cell - however the VBA would be slightly different for each method.
It might be worth recording a Macro doing your steps then looking to see if you can amend the code to provide you with more flexibility.
Happy to help if you can make a start
Purfleet
Alright, let me try. Thank you. 🙂
