In excel column A, I have som numbers, for example cell A1 to A6 like this:
98765
87654
76543
65432
54321
43210
My challenge is that I want to move all the numbers in column A (down to last cell with value) into cell A1, separating cell values with a semicolon (without spaces). For example cell A1 like this:
98765; 87654; 76543; 65432; 54321; 43210
Anyone know a vba that can do this job?
98765
87654
76543
65432
54321
43210
My challenge is that I want to move all the numbers in column A (down to last cell with value) into cell A1, separating cell values with a semicolon (without spaces). For example cell A1 like this:
98765; 87654; 76543; 65432; 54321; 43210
Anyone know a vba that can do this job?