Converting list of numbers in Excel to a string of text in Word

[clint-50025]

I have a list of numbers in Excel and I would like to convert this to a
string of text in either Word or Notepad. These need to be separated with a
semicolon. I have figured out how to add the semicolon in Excel (using a
formual something like "A1&B1") and then copying and pasting to a new column.
Just need to convert this list to a string with no spaces between. The end
result (in Word) would look like: 123456;246888;789456;654123...etc. Any
ideas?

 

[Pete_UK]

Assuming your numbers are in column A, put this formula in B1:

=A1

and this in B2:

=IF(A2="",B1,B1&";"&A2)

Copy this formula down as far as you need to, and the combined text
will be in the bottom cell.

Hope this helps.

Pete

 

[David Biddulph]

Your formula =A1&B1 *will* produce a string with no spaces between the
content of A1 and B1.
If you wish to separate them with a semi-colon, the formula is =A1&";"&B1

 

[clint-50025]

This worked great! Thanks for the idea. Just had to copy the last cell,
paste special --> values to a new cell, then copied that into word. I
appreciate your help!