How to add alphanumeric data? (e.g., 1C+2D)
If you always have one digit to add, you can use:
=left(a1,1)+left(a2,1)+left(a3,1)
If you can have more than one digit, but only one letter, you can use:
=left(a1,len(a1)-1)+...
If you have something else, let us know.
--
Regards,
Fred
wrote in message
ups.com...
I have a set of alphanumeric data. How do I add just numbers, leaving
letters behind?
For instance, 1X+2X+3X should = 6. Any suggestions?
Thanks!
|