How to abstract a number from a string?

Hi all,

I'm trying abstract second number from a cell.
If cell a1=1234, how do I abstract 2 using a function?
I will need to use 2 for some math calculation.

I tried this but it don't work.

Function test(num As String)
test = num.char(1)
End Function

Thank for assisting.
--
Danny

Function test(num As String) as long
test = mid(num,2,1)
End Function

(with no validity checks at all!)

Danny Hoon wrote:
>
> Hi all,
>
> I'm trying abstract second number from a cell.
> If cell a1=1234, how do I abstract 2 using a function?
> I will need to use 2 for some math calculation.
>
> I tried this but it don't work.
>
> Function test(num As String)
> test = num.char(1)
> End Function
>
> Thank for assisting.
> --
> Danny

--

Dave Peterson

Thanks Dave!!!
Care to explain this line?
Function test(num As String) as long <== you are casting the String to a
Long data type?

--
Danny

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Function test(num As String) as long
> test = mid(num,2,1)
> End Function
>
> (with no validity checks at all!)
>
> Danny Hoon wrote:
>>
>> Hi all,
>>
>> I'm trying abstract second number from a cell.
>> If cell a1=1234, how do I abstract 2 using a function?
>> I will need to use 2 for some math calculation.
>>
>> I tried this but it don't work.
>>
>> Function test(num As String)
>> test = num.char(1)
>> End Function
>>
>> Thank for assisting.
>> --
>> Danny
>
> --
>
> Dave Peterson

Maybe.........

=MID(A1,2,1)*1

Vaya con Dios,
Chuck, CABGx3


"Danny Hoon" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> I'm trying abstract second number from a cell.
> If cell a1=1234, how do I abstract 2 using a function?
> I will need to use 2 for some math calculation.
>
> I tried this but it don't work.
>
> Function test(num As String)
> test = num.char(1)
> End Function
>
> Thank for assisting.
> --
> Danny
>
>

Yep.

You said that it would be used for further math calculations.

Danny Hoon wrote:
>
> Thanks Dave!!!
> Care to explain this line?
> Function test(num As String) as long <== you are casting the String to a
> Long data type?
>
> --
> Danny
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > Function test(num As String) as long
> > test = mid(num,2,1)
> > End Function
> >
> > (with no validity checks at all!)
> >
> > Danny Hoon wrote:
> >>
> >> Hi all,
> >>
> >> I'm trying abstract second number from a cell.
> >> If cell a1=1234, how do I abstract 2 using a function?
> >> I will need to use 2 for some math calculation.
> >>
> >> I tried this but it don't work.
> >>
> >> Function test(num As String)
> >> test = num.char(1)
> >> End Function
> >>
> >> Thank for assisting.
> >> --
> >> Danny
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson