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

On Wed, 7 Dec 2005 21:13:29 +0000 (UTC), Saxman
<john.h.williams(removethis)@btinternet.com> 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

[Saxman]

On Wed, 7 Dec 2005 15:19:17 -0600, cvolkert wrote:

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

That works a treat! Many thanks.

[Saxman]

On Wed, 07 Dec 2005 14:03:29 -0800, Gord Dibben wrote:

> Data>Text to Columns>Delimited by "Other".
>
> Type in ( and Finish.
>
>
> Gord Dibben Excel MVP
>

TU