Parenthesis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GitFinger - 29 Mar 2006 16:32 GMT

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

Reply to this Message

Bob Phillips - 29 Mar 2006 16:56 GMT

Try

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

where A1 is that text value

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi All,
>
[quoted text clipped - 5 lines]
>
> D

Reply to this Message

GitFinger - 31 Mar 2006 15:27 GMT

Many Thanks!

> Try
>
[quoted text clipped - 12 lines]
>>
>> D

Reply to this Message