function that take the number

mgm90210M

Board Regular
Joined
Feb 14, 2013
Messages
92
a
b
c
d
e
f
g
h
2
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl64 { color: blue; text-decoration: underline; }</style>
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>
Painting, Drawing & Art Supplies (336,815)

<colgroup><col style="width:65pt" width="65"> </colgroup><tbody>
</tbody>

<colgroup><col style="width:65pt" width="65"> </colgroup><tbody>
</tbody>
336815
3
<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>
Beading & Jewelry Making (617,347)

<colgroup><col style="width:65pt" width="65"> </colgroup><tbody>
</tbody>
617,347
4
5
6
7
8

<tbody>
</tbody>



please

i need your help
in b3 i put the text Painting, Drawing & Art Supplies (336,815)
i need that in c2 a function that take the number 336815 and put in on their
also in need to drag the function all of column c
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
In c1 put
Code:
=MID(B1,SEARCH("(",B1)+1,SEARCH(")",B1)-SEARCH("(",B1)-1)

copy down as far as required
 
Last edited:
Upvote 0
Simply reformat the column to not show the thousand seperator
 
Upvote 0
That won't work because MID returns a text string, you would have to coerce it.

But here's an alternative formula:
=-REPLACE(B1,1,FIND("(",B1)-1,"")
 
Upvote 0
OOwww...thanks Scott...bit early in the morning for me...:oops:
 
Upvote 0
using Michael's suggestion...
=--MID(B1,SEARCH("(",B1)+1,SEARCH(")",B1)-SEARCH("(",B1)-1)
 
Upvote 0
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:291px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Painting, Drawing & Art Supplies (336,815)</td><td style="text-align:right; ">336815</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Beading & Jewelry Making (617,347)</td><td style="text-align:right; ">617347</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C1</td><td >=-REPLACE(B1,1,FIND<span style=' color:008000; '>("(",B1)</span>-1,"")</td></tr><tr><td >C2</td><td >=-REPLACE(B2,1,FIND<span style=' color:008000; '>("(",B2)</span>-1,"")</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span>
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top