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?

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?

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!

"Pete_UK" wrote:

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?

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
--
David Biddulph

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?