Need a help

[vinodh]

Hi

In excel the cell value contains " Smart» SQ-1251916 for SCC SERVICES In progress " like this i am having more than 1000 columns , but not in a standard format , but i need only " SQ-####### "

For eg: Column format
Col 1 : Smart» SQ-1251916 for SCC SERVICES In progress
Col 2 : SQ-1256890 pour CFI LYON - client final
i want only SQ - # # #.

Anybody well versed in macro can u do this for me.

Thanks & regards
Vinodh

 

[Sachin.Medhe]

After SQ- always having 7 numbers ?

 

[vinodh]

yes for every SQ it contains 7 numbers..

 

[Sachin.Medhe]

Try out !

Call SQnumber(Give Refrence)

Public Function SQnumber(A As String)

SQnumber = Left(Right(A, Len(A) - WorksheetFunction.Find("SQ", A, 1) + 1), 10)


End Function