If they are all numerical characters, you could use something like the CDbl
function to change them to numbers.
If the numerical characters are at the beginning of the string, something
like a street address of 123 Main St., then you can use the Val function to
extract the leading numbers.
If the numerical characters are spread around in the string, that can be a
problem.
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.
