Removing spaces or transferring columns as one chain of numbers

[47magic]

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

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

Note:
That value will be TEXT.
If you need it to be numeric....

Please Login or Register  to view this content.

Does that help?

[47magic]

thank you!!!
Works like a charm.

Once again, this forum rocks!