Hi all!
I am pasting a lot of data into excel from word in, it all comes into the one column in the following format:
Data1A
Data1B
Data1C
Data1D
Data2A
Data2B
Data2C
Data2D
and so on. What I need to do is move it like this:
Data1A / Data1B / Data1C / Data1D
Data2A / Data2B / Data2C / Data2D
and so on. I tried doing a VBA macro but didn't have any luck!
Thanks in advance!
Bookmarks