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

I

ian78

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
 
D

Duke Carey

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

ian78

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

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Removing text between hyphens and removing the hyphens 8
How do I remove the top half of a block interval? 1
How can I remove all hyphens in a column without retyping? 2
How can I print rows that go outside of the page without shrinking the text? 0
number of months and days between two dates without approximation 3
Word 2016: How do I change a REF field code that references a Heading style to Arabic when the Headi 1

Top