frank_m
01-22-2011, 06:50 AM
Using VBA (not a formula), I need my Cell A1 value to equal the number value at the end of a string.
Example strings
value equals 1 for these three
"abc-1"
"200-1"
"50-01"
value equals 12 for these three
"100-12"
"ef-012"
"SST-012"
I only used the quote's to demonstrate that these are all strings
I realize that using the minus sign as a separator in the original data likely complicates things, but that's the data layout that I'm required to work with.
Thanks
Example strings
value equals 1 for these three
"abc-1"
"200-1"
"50-01"
value equals 12 for these three
"100-12"
"ef-012"
"SST-012"
I only used the quote's to demonstrate that these are all strings
I realize that using the minus sign as a separator in the original data likely complicates things, but that's the data layout that I'm required to work with.
Thanks