Parsing Data

[Saxman]

4.4(7.0)
8.2(6.0)
6.8(3.0)
3.2(20.0)
10.0(6.0)
7.0(11.0)
7.2(12.0)
18.0(2.0)
3.15(8.0)
8.8(3.0)

Could somebody please provide me with the function to remove the brackets
and the data contain therin, i.e. in the first example, I need 4.4 copied
to another cell?

The first example is in cell E3 of my spreadsheet.

TIA

 

[cvolkert]

This formula should do the trick. Let me know if not - Chad

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

 

[Gord Dibben]

Data>Text to Columns>Delimited by "Other".

Type in ( and Finish.


Gord Dibben Excel MVP

 

[Saxman]

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

That works a treat! Many thanks.

 

[Saxman]

Data>Text to Columns>Delimited by "Other".

Type in ( and Finish.


Gord Dibben Excel MVP

TU