Remove Characters

  • Thread starter Thread starter VINCE
  • Start date Start date
V

VINCE

Hello, How can I remove the dashes in a cell. For Eg. 259-
96-6987 to display 259966987. Thanks
 
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
 
Vince

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

will do the job.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only, please.
 
You must log in or register to reply here.

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

Concatenating two variable fields into a static length text field 2
Remove dashes from phone numbers in a spreadsheet 3
how to use vlookup in this case 9
Displaying zeros in cells 2
how do I use only 2 characters in a field in a formula 2
Review Vidonn F1 bone conduction headphones 0
repeating a character across the width of a column 4
How do I remove non-numerical charaters from a string? 3

Back
Top