Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add alphanumeric data? (e.g., 1C+2D)
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add alphanumeric data? (e.g., 1C+2D)
Try this UDF:
Function noname(r As Range) As Variant v = r.Value For i = 65 To 90 v = Replace(v, Chr(i), "") Next For i = 97 To 122 v = Replace(v, Chr(i), "") Next noname = Evaluate("=" & v) End Function use in worksheet like: =noname(A1) -- Gary''s Student - gsnu200719 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add alphanumeric data? (e.g., 1C+2D)
On 9 May 2007 05:52:33 -0700, wrote:
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! If you're strings might be more complicated than what you've posted, you could download and install Longre's free morefunc.xll add-in from http://xcell05.free.fr/ Then use this formula: =EVAL(REGEX.SUBSTITUTE(A1,"[A-Za-z]")) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort AlphaNumeric Data sequentially with spaces | Excel Discussion (Misc queries) | |||
Finding unique entries among two columns of alphanumeric data | Excel Worksheet Functions | |||
sort alphanumeric data | New Users to Excel | |||
can you create a chart in excel with alphanumeric data? | Charts and Charting in Excel | |||
How to Perform Lookup on Alphanumeric Data? | Excel Discussion (Misc queries) |