Remove characters from a text string using a formula

D

duncrbrt

I need a formula where I can remove characters such as . - space or _. These
characters can show up anywhere in the text string. i.e.,
123-abc should be 123abc
123 abc should be 123abc

any help would be greatly appreciated,

Regards,

Robert
 
B

Biff

Hi!

Try this to remove periods(or decimal points), dashes(-), spaces, and
underscores( _ )

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"-",""),"
",""),"_","")

Biff
 

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
Search and lookup functions 1
How to Remove Forbidden Characters 1
Formating bolded text exclusively. 0
EXCEL read a text string as scientific notation 7
Problem with MS Word paragraph and character styles: format getting messed up 2
Remove Sequential Repeats 2
Changing sender address using macros 2

Top