Remove Characters

V

VINCE

Hello, How can I remove the dashes in a cell. For Eg. 259-
96-6987 to display 259966987. Thanks
 
G

Greta

Go to Edit, Replace, and in the "Find What" spot put -
,then hit Replace All. It will yank your dashes and
replace them with nothing...that should work.
Greta
 
L

Leo Heuser

Vince

=SUBSTITUTE(B17,"-","")

will do the job.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.
 

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

Remove all formatting charactersf except for paragraph and cr/lf 0
Countdown macro - display settings 2
Word 97 Password 0
Concatenating two variable fields into a static length text field 2
Remove Identical words 0
Small Thick "Bar" Below Last Typed Line ? 0
Autocorrection pecularity 1
How to remove external organization from Office. 0

Top