Hi Suman
u can try below UDF also
'Below User Define Function extract Number from string
Function ExtractNumber(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
Select Case Asc(Mid(rng.Value, i, 1))
Case 0 To 64, 123 To 197
ExtractNumber = ExtractNumber & Mid(rng.Value, i, 1)
End Select
Next
Dear Suman,
Please try below function and see attached sheet
Through Excel
B1=MID(B3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B3&"0,1,2,3,4,5,6,7,8,9")),LEN(B3))
Press ctrl+shift+Enter
C1==LEFT(A3,LEN(A3)-LEN(B3))
Through VBA
Function extractonlytxt(txt)
Dim txt1 As String
txt1 =
hi Suman,
check the below mentioned link
sanjib
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
On Wed, Oct 5, 2011 at 3:12 PM, Suman wrote:
> Hi Group
> I have multiple data in column A (Alphabet with numeric values) n i want to
> s
Hi Group
I have multiple data in column A (Alphabet with numeric values) n i want to
separate them?
Available Data
*A*
suman1456 Sam221 Manni457
I want like this:
suman 1456 Sam 221 Manni 457
--
Suman Kumar
Mob: +91 9810333884
--
--
