Hello,
I have a large column of data (pasted from a website) which I would like to see broken into rows. the data presents as:
change #
(random empty spaces)
title of change
(random empty spaces)
Testing notes
(random empty spaces)
change #
(random empty spaces)
title of change
(random empty spaces)
Testing notes
(random empty spaces)
change #
(random empty spaces)
title of change
(random empty spaces)
Testing notes
(random empty spaces)
change #
(random empty spaces)
title of change
(random empty spaces)
Testing notes
(random empty spaces)
and so on and so on -
I would like it to display as follows:
change # title of change Testing notes
change # title of change Testing notes
change # title of change Testing notes
change # title of change Testing notes
change # title of change Testing notes
change # title of change Testing notes
change # title of change Testing notes
All data pasted into Column A.
Anyone have a macro to help? i've searched a few other posts, and found similar problems, but those macros fail on me. I'm VERY novice at macros, so any instructions would be super helpful.
Thank you in advance.
Bookmarks