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
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
Hi!
Try this to remove periods(or decimal points), dashes(-), spaces, and
underscores( _ )
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,".",""),"-",""),"
",""),"_","")
Biff
"duncrbrt" <[email protected]> wrote in message
news:[email protected]...
>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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks