Removing Hyphens from a Number

  • Thread starter Thread starter Trebor249
  • Start date Start date
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.
 
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)
 
Back
Top