This will extract any Letter and number such as B2004 from your string. Place 
in a REGULAR module and use
=xtract(a1) 
and copy down to get A89, etc

Function Xtract(ByVal ref As String) As String
Dim rx As Object, arr As Object, i As Integer
Set rx = CreateObject("VBscript.Regexp")
With rx
    .Pattern = "([A-Z][0-9]*)"
    .Global = True
    If .test(ref) Then Set arr = .Execute(ref)
End With
For i = 0 To arr.Count - 1
    If i = 0 Then
        Xtract = arr(i)
    Else
        Xtract = Xtract & "," & arr(i)
    End If
Next
End Function

Don Guillett
SalesAid Software
dguille...@gmail.com

From: vijayajith VA 
Sent: Sunday, December 25, 2011 3:31 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ help

Hi , 

i have some data like 1) floo see r eree s seer(A23),seruo serereserrser seeess 
kke(A89)
                                2) folow re e ser se ser(S89)

I want to extract only nos inside the bracket


please suggest me for some formula or code

Thanks
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

Reply via email to