Parenthesis

Hi All,

I have a column that contains a number and a number enclosed in parenthesis,
is it possible to use the number that is enclosed for a calculation ie
c1=b1*a1"(#)"

Thanks

D

Try

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

where A1 is that text value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"GitFinger" <davec@sockstechmate.co.uk> wrote in message
news:122la2cqf6mbbfa@corp.supernews.com...
> Hi All,
>
> I have a column that contains a number and a number enclosed in
parenthesis,
> is it possible to use the number that is enclosed for a calculation ie
> c1=b1*a1"(#)"
>
> Thanks
>
> D
>
>

Many Thanks!


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:u0TiQl0UGHA.4348@TK2MSFTNGP09.phx.gbl...
> Try
>
> =SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")
>
> where A1 is that text value
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "GitFinger" <davec@sockstechmate.co.uk> wrote in message
> news:122la2cqf6mbbfa@corp.supernews.com...
>> Hi All,
>>
>> I have a column that contains a number and a number enclosed in
> parenthesis,
>> is it possible to use the number that is enclosed for a calculation ie
>> c1=b1*a1"(#)"
>>
>> Thanks
>>
>> D
>>
>>
>
>