Parenthesis

  • Thread starter Thread starter GitFinger
  • Start date Start date
G

GitFinger

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)
 
Many Thanks!


Bob Phillips said:
Try

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

where A1 is that text value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numbering rows 6
VBA set thick borders around non empty cells in range 0
MACRO RUN random percentage and copy of column values 1
How do i find and replace words in parenthesis? 5
Cell colour change if formula displays false 3
Auto Insert Parenthesis 3
BIOS 2
Active Column Ref In a Formula 4

Back
Top