Hello!
I've come across a problem at work, where I have large spreadsheets with columns of cells like this:
Apple ABC 123
Pear de 4
Banana 665 F
That is, one relevant word followed by some other, irregular, stuff. Then a linebreak, a new relevant word, and other stuff. Note that the number of lines in each cell varies, from 0 to maybe ten.
I need to copy-paste this into a Sharepoint sheet, and it needs to be on this form:
Apple; Pear; Banana
My first thought was that this would be a great thing to automate, and hence a reason to learn Excel macros, so I've bought Walkenbach's book "Excel 2013 Power Programming with VBA". However, I'm quite lost, to say the least.
So my questions to you, is:
a) It is at all possible to create a VBA macro that transforms a column of text in the way that I want it?
b) How? What structure and functions should the code have?
c) Can you recommend me any "key words" or information sources for this specific type of macros? I've realized that VBA is usable for way more things than I thought, so I don't even know where to read in Walkenbach's book... or elsewhere.
Thank you!
Alfred
Bookmarks