Brilliant. I have used the copy & paste special feature for shorter lists,
manually typing the ;+del+end and repeating until all the numbers were
linked. But I didn't know about using the replace feature. I actually have
to copy this list of numbers into another software program, so whether the
numbers are merged in Excel or Word doesn't really matter. Thank you for
saving me from carpal tunnel!

"~L" wrote:

It isn't a formula, but this could work:
Highlight the numbers you want.
Copy using CTRL+C
Create a new word document
Paste Special using the edit menu and paste it as plain text.
Press CTRL+H and in the find field put ^w and in the replace field put ;
Still on the replace menu, put ^p in the find field and ; in the replace
field.
Visually inspect the data to make sure there are no ;;; (There were in my
test data because I had blank rows). If there are, find ;;; and replace with
;.
Now copy that text, and paste it back into Excel.