DataText to ColumnsDelimited by "Other".

Type in ( and Finish.


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 21:13:29 +0000 (UTC), Saxman
wrote:

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