View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default removing dashes from numbers

Highlight the column and do Find & Replace (CTRL-H):

Find What: -
Replace with: (leave empty)

Click Replace All.

Note that if you have "numbers" like 0012-3456, you will lose the
leading zeros and end up with 123456.

Hope this helps.

Pete

On Jun 21, 4:39 pm, "Pat Jones" wrote:
Hi;

I have a long column of numbers that contain "-" (I call them dashes). I
need to remove the dashes from these 3000+ numbers. Is there a way to
automate this process?

Thanks;

Pat