Thread: Parsing Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Saxman
 
Posts: n/a
Default Parsing Data

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