Thread: Concatenate
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
 
Posts: 177
Default Concatenate

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.