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

On Feb 3, 9:31*pm, clint-50025
wrote:
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?