Removing Hyphens from a Number

T

Trebor249

I have a huge database of numbers (several thousand) with hyphens in
them and I want to remove the hyphens in some automated fashion. For
instance:

42-291-32455 change to 4229132455

Does anyone know of a way to do this? Thanks.
 
B

Bob Phillips

Use a formula to put number in an adjacent cell

=SUBSTITUTE(A1,"-","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Removing text between hyphens and removing the hyphens 8
delete hyphens within a cell while maintaining the data therein 1
Automatically removing hyphens from ID# or SSN. 8
Remove Hyphens from a number 2
How can I remove all hyphens in a column without retyping? 2
Formula or Function to Set Many Existing Numbers in Same Format? 4
sorting cells that contain spaces and hyphens 2
Different autoformat options for different templates? 1

Top