Guys (Gals),
Please help.
I have a (1000-row) file with a single digit in 12 consecutive columns. I have to find a way to transfer them into a one, twelve digit long number (without spaces between digits).
Example:
A1=8, B1=3, C1=4, D1=5, E1=3, F1=9, G1=6, H=5, I1=7, J1=3, K1=9, L1=3
I need the outcome to be 834539657393
P.S. I tried saving the file as .txt and inserting it, but best I ended up with is a column with all these digits with spaces in between them (8 3 4 5 3 9 6 5 7 3 9 3).
Thank you in advance
Bookmarks