Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.
=1*MID(D3,MATCH(FALSE,ISERROR(1*MID(D3,ROW($3:$12),1)),0),255)
Extract.xlsm
'Install code in a regular module sheet
Function GetNumber(sText As String, Optional iStart As Integer = 3, Optional iLast As Integer = 12)
Dim i As Integer
GetNumber = ""
For i = iStart To iLast
If IsNumeric(Mid(sText, i, 1)) Then
GetNumber = Val(Mid(sText, i))
Exit For
End If
Next
End Function
=1*MID(D3,MATCH(FALSE,ISERROR(1*MID(D3,ROW($1:$10),1)),0),255)
The only returned value is 123 for all cells. Does that mean I'll have to repeat the array formula for E3:E12?If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.