separation of numbers and text

[kashifzia423]

sir please tell me how can i make separation between text and numbers from a same cell?

 

[kashifzia423]

thanks

 

[Rick Rothstein]

Just to address the idea of using a macro... you could do that by translating my previously posted formulas into VB functions like this

Function TrailingNumber(Cell As Range) As String
  TrailingNumber = Mid(Cell, Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & Cell.Address & "&""0123456789""))"))
End Function

Function LeadingText(Cell As Range) As String
  LeadingText = Left(Cell, Evaluate("MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & Cell.Address & "&""0123456789""))") - 1)
End Function

 

[kashifzia423]

sir please tell me how can i find duplicate value/number by formula

 

[hiker95]

Stefyu89,

For the sake of providing multiple approaches to tackle the same issue, these are my macros (Not so brillant as RegExp expressions from Hiker 95 but .... ) :

Thank you very much for that.


kashifzia423,

thanks

You are very welcome. Glad we could help.

And, come back anytime.