Removing Hyphen(s)

  • Thread starter Thread starter Curtis
  • Start date Start date
C

Curtis

I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks
 
Highlight the cells and use Find & Replace (CTRL-H) - Find hyphen and
replace with nothing.

Hope this helps.

Pete
 
Do a find and replace (Cntrl H) and replace the "-" with nothing ("-" without
the qoutes)
 
Back
Top