Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Non-Numerics from String
I need a function to remove "$" and all capitalized letters (i.e. A, B, etc)
from a string variable. Assuming that regular expressions is the way to to using the Replace method. Any ideas on how to do this via VBA? Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove text from string | Excel Worksheet Functions | |||
Remove specified value from string | Excel Programming | |||
Remove specified string from value | Excel Programming | |||
Remove specified value from string | Excel Programming | |||
Remove the last letter from a string! | Excel Programming |