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

  • Thread starter Thread starter clint-50025
  • Start date Start date
C

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?
 
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
 
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!
 
Back
Top