Excellent formula Sam... Awesome
Regards,
DILIPandey
On 10/16/11, Sam Mathai Chacko wrote:
> In keeping with Noorain's VBA function, use this formula as an array. This
> extracts all numbers irrespective of whether the numbers are together, or
> scattered across the text like ABC123DEF, or A
In keeping with Noorain's VBA function, use this formula as an array. This
extracts all numbers irrespective of whether the numbers are together, or
scattered across the text like ABC123DEF, or A1B2CD3EF
=SUM(IFERROR(MID(A1,LARGE(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)^0)*ROW(INDIRECT("1:"&
Dear Neil,
Please try it to find integer..
Function only_integer(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
If VBA.IsNumeric(Mid(rng, i, 1)) = True Then
only_integer = only_integer & Val(Mid(rng, i, 1))
End If
Next
End Function
--
Thanks & regards,
Noorain Ansari
*http://exc
nd With
>
> v = Split(s)
> With Range("l3").Resize(UBound(v) + 1)
> .Value = Application.Transpose(v)
> .Sort key1:=.Item(1), Order1:=xlAscending, Header:=xlNo
> End With
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> Fro
ending, Header:=xlNo
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: neil johnson
Sent: Sunday, October 16, 2011 5:54 AM
To: excel-macros
Subject: $$Excel-Macros$$ How to extract number in cell
Hi All,
How to extract number form
Hi All,
How to extract number form the cell .
For example
abc123abc
wc34agh
783abcd
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld