Removing hypen from existing text

M

mePenny

I've asked to place the hypen into the text, now i need to remove the hyphen:

Example of text with hypen:
G-212DA

Text without hypen:
G212DA

Thank you in advance.
 
D

Dave Peterson

Select the range to fix.
Edit|Replace
What: - (dash)
with: (leave blank)
replace all
 

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

Adding hyphen to text in cell 6
Removing text between hyphens and removing the hyphens 8
REPLACE command drops leading zeros 4
Microsoft.Jet.OLEDB error with csv file names 0
Using REPLACE command removes leading zeros 2
Remove the hypens from a social security number 2
Extracting (Copying) Text to the Right of a Hyphen 3
optional hypens showing as dashes 1

Top