try this udf
Function nm(rng As Range) As String
Dim cl As Range
For Each cl In rng
If Mid(cl.Value, 3, 1) = "-" And Mid(cl.Value, 7, 1) = "-" Then
nm = Left(cl.Value, 12)
Exit For
End If
Next
End Function
if its nt working in that case share s
Thanks for the file, one minor problem
if we have some texts in the same cell, what should I do
for example:
\
nn-nnn-n Text Commision Tax etc etc
I tried Left(cl.value,12) but it didn't work
Thanks
On Tue, Jul 9, 2013 at 9:24 AM, ashish koul wrote:
> chk the attached file . see if it hel
chk the attached file . see if it helps
On Tue, Jul 9, 2013 at 7:47 PM, wrote:
> Here is a sample file with 2 example sheets
> On Monday, July 8, 2013 1:43:08 PM UTC-5, ha...@mst.edu wrote:
>>
>> Hi All,
>> Basically, I want to find a text from specific category and return the
>> text/number to
Here is a sample file with 2 example sheets
On Monday, July 8, 2013 1:43:08 PM UTC-5, ha...@mst.edu wrote:
>
> Hi All,
> Basically, I want to find a text from specific category and return the
> text/number to a specific cell.
> For example,
> API NUMBER: (return the value here)
> Find API number
Share some more data with an example.
Regards
Prince
On Tuesday, July 9, 2013 12:13:08 AM UTC+5:30, ha...@mst.edu wrote:
>
> Hi All,
> Basically, I want to find a text from specific category and return the
> text/number to a specific cell.
> For example,
> API NUMBER: (return the value here)
>