Removing Hyphen(s)

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
 
P

Pete_UK

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

Hope this helps.

Pete
 
I

Iriemon

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

DOCPROPERTY field switches and non-breaking hyphens and spaces 5
Macros to convert Data into date format and then plot in graph 7
Concatenate with hyphens 5
How to disable Alt+s in Outlook 365 0
Issues with hyphens in Caption changing to em dash 1
How to Create an S-Curve from Custom Field? 0
Inserting a hyphen after the 3rd character 3
Format cell so number entered will show only one way 2

Top