Refininf Excel Formula

[weightinwildcat]

Good afternoon. This is a followup posting to one I made a few days ago.

I have created this formula in Excel Starter 2010:

=SUM(RIGHT(G4403,LEN(G4403)-4),RIGHT(LEFT(G4403,LEN(G4403)-6), LEN(LEFT(G4403,LEN(G4403)-6))-1))

The purpose is to extract the numbers in a string of this type (S50W12134 - pertaining to an address) and present the sum. The problem is that the numbers are of varying length. Does the starter edition have any VBA window in which I can program a solution? Alternatively, is there a way I can create a more general formula to do this job, or even a macro? (Some cells have only numbers, or something like W1234.)

Any thoughts or suggestions would be welcome.

Thank you in advance.

 

[SkipVought]

hi,

and present the sum

The sum of WHAT? all the DIGITS?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[weightinwildcat]

To be precise, if you strip out the digits you would have two numbers. I want to add those two numbers together.

Sorry if I was not clear.

 

[Gavona]

So are the patterns you may encounter:

9
A9
A9A9

Where 9 is an integer number of any length and A is a single Alphabetic character.

Your original post in case others are interested: thread436-1639133

Gavin