Good Day Experts!
I am a novice at Excel 2010 and am not sure if what I wish to do is possible.
I have 6541 rows with values only in column A. The values are 4 long and have up to 3 preceeding 0's. I would like to put ' in front and in back of the value('0002'). Then I would like to put all the values together in a string seperated by a comma('0002','0003','0004' etc).
Bascially I am going to use these values in a SQL query.