Parsing Parentheses

[Saxman]

I need to get rid of the parentheses below.

Data is in cells A1:A8

1.39(87.0)
16.5(5.0)
7.4(2.0)
8.2(12.0)
25.0(12.0)
40.0(2.0)
44.0(2.0)
48.0(2.0)

I want the data to end up like this:-
1.39
16.5 etc.

 

[lhkittle]

I need to get rid of the parentheses below.



Data is in cells A1:A8



1.39(87.0)

16.5(5.0)

7.4(2.0)

8.2(12.0)

25.0(12.0)

40.0(2.0)

44.0(2.0)

48.0(2.0)



I want the data to end up like this:-

1.39

16.5 etc.

Try:

=--LEFT(A1,FIND("(",A1)-1)

Howard

 

[Saxman]

That works absolutely fine. I am very grateful to you.

Thanks.