copying numbers without separator

**qwyz** · 10-09-2008, 05:33 AM

Hi,
I have a list of number that I would like to copy into a text file. The format is like this:
123-4567-8910-1234
123-4567-8910-1234
I have a list of hundreds of these, and I need to enter them into a txt file WITHOUT the "-". Rather than entering them in one by one manually, is there any way I can format the numbers so that excel will remove the "-", and then I could copy all of them at once?

Thanks in advance!

**arthurbr** · 10-09-2008, 05:59 AM

Hi and welcome to the board
Try Edit - Replace : What "-" ( no quotes) With ( nothing)
Click "Replace all"
Then save as CSV file

**dominicb** · 10-09-2008, 06:05 AM

Good morning qwyz

Originally Posted by qwyz

I have a list of hundreds of these, and I need to enter them into a txt file WITHOUT the "-".

Have a look at my response in this thead, which includes a VBA routine to output the contents of a range direct to a text file without the "quote" marks.

HTH

DominicB