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

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
 
G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I remove all hyphens in a column without retyping? 2
How do I take hyphens out of phone numbers? 2
how do i calculate the difference between two numbers? 7
How do i get the hyphen to stay in phone numbers? 1
remove spaces between numbers 2
how do I transpose items from another sheet? 6
How to remove newlines from worksheet 1
how do i highlight the ten highest numbers in a range? 3

Top