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)
 

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

Concatenate with hyphens 4
Remove data that preceeds a character 6
remove hyphens from a list of part numbers 1
Fixing Hyphens 2
Partial text returned from a query 0
Format cell so number entered will show only one way 2
Inserting a hyphen after the 3rd character 3
odd non-breaking hyphen behavior 9

Back
Top