How to cut the parentheses value from a row of cells?

[jmcarper09]

Hey there,

I was hoping someone could help me find a shortcut for cutting the parentheses value from a row of cells. The cells in my row each have a percentage and confidence interval value in parentheses and I would like to cut out the confidence interval. I have about sixty columns to work with, so I'd like to be able to copy a formula across a row.

Ex: I'd like to take "29% (6%-7%)" and take out the "(6%-7%)" without having to individually cutting each value out.

Any help is much appreciated.

Thanks,
Jane

 

[VoG]

Hi. Maybe like this

Excel Workbook
	A
1	29% (6%-7%)
2	(6%-7%)
Sheet5

 

[jmcarper09]

Thanks for replying, VoG.

I just tried that formula, but that leaves me with the parentheses only "(6%-7%)", instead of the "29%."

Further tips?

 

[VoG]

Try

=LEFT(A1,FIND(" (",A1))+0

Format as %

 

[hiker95]

jmcarper09,

How about:

Excel Workbook
	A
1	29% (6%-7%)
2	29%
Sheet1

 

[jmcarper09]

Works great. Thanks again!

 

[BenMiller]

Why don't you use FIND/REPLACE?

 

[jmcarper09]

Ben,

I'm not familiar with FIND/REPLACE-- how would I use that in this scenario?

 

[BenMiller]

Hit CTRL+F, search for "(" without the quotes and leave the replace field empty. Do it again for the ")".

 

[shg]

Find and replace (*) with nothing