Deleting all non-numeric characters in a text-string?!

**Cygnos** · 04-01-2008, 05:37 AM

Hi all!

I would like to delete all the non, numeric characters in a text-string, but keep the operator "+".
Column A looks something like this right now:
Best.nr St. 5 +
Best.nr per par 100 +
Best.nr paket 50 +

and so on...
Can you help me?

**davesexcel** · 04-01-2008, 06:47 AM

Here is one way...

This may seem Difficult, but it is not!!
place this udf in a module
Alt F11, insert,module, copy and paste code there

Please Login or Register  to view this content.

Originally found here http://www.ozgrid.com/forum/showthread.php?t=73788
on the excel spread sheet enter this
Best.nr St. 5 +
in B1 enter this formula
=ExtractNumeric(A1)&" +"