Parsing Data

S

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
 
C

cvolkert

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

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

Gord Dibben

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

Type in ( and Finish.


Gord Dibben Excel MVP
 
Top