Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove characters from a text string using a formula
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 |
#2
|
|||
|
|||
Hi!
Try this to remove periods(or decimal points), dashes(-), spaces, and underscores( _ ) =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,". ",""),"-","")," ",""),"_","") Biff "duncrbrt" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
Remove text leading zero in text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Remove single text characters | Excel Discussion (Misc queries) |