How do i remove the hyphens between numbers without having to edi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i remove the hyphens between numbers without having to edit without
having to use edit manually. I have a column of 3000 numbers similar to this

0-7643-2300-5, which neds to read 0764323005

Any ideas
Regards Ian
 
First, format the whole range of entries as Text.
Second, highlight the cells and press Ctrl-H to bring up the Search &
Replace dialog box. Search for the hyphen and replace it with nothing.
 
ian78 said:
How do i remove the hyphens between numbers without having to edit without
having to use edit manually. I have a column of 3000 numbers similar to this

0-7643-2300-5, which neds to read 0764323005

Any ideas
Regards Ian
Click to expand...

Thanks Duke
Regards Ian
 
Back
Top