Hi.
I couldnt find solution for a simple problem at first sight.
In a short, I have a row with some codes in cells. These codes were made by letters and digits.
For example:
CE4, BV8, G2, CX, AC - these are codes in a separate cells let say in a range (a1:a5)
What I need is a function or vba code which is going to extract digits from each cell and then make a sum of extracted values.
In this case result would be: 4+8+2=14
Of course, I have many rows, so formula in a6 would be best solution, so I could just pull it down to the last row.
Thanks for any help.
I couldnt find solution for a simple problem at first sight.
In a short, I have a row with some codes in cells. These codes were made by letters and digits.
For example:
CE4, BV8, G2, CX, AC - these are codes in a separate cells let say in a range (a1:a5)
What I need is a function or vba code which is going to extract digits from each cell and then make a sum of extracted values.
In this case result would be: 4+8+2=14
Of course, I have many rows, so formula in a6 would be best solution, so I could just pull it down to the last row.
Thanks for any help.
