Remember Me?

#1
December 7th 05, 09:13 PM posted to microsoft.public.excel.misc
 Saxman Posts: n/a
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

#2
December 7th 05, 09:19 PM posted to microsoft.public.excel.misc
 cvolkert Posts: n/a
Parsing Data

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

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

--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380

#3
December 7th 05, 10:03 PM posted to microsoft.public.excel.misc
 Gord Dibben Posts: n/a
Parsing Data

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

#4
December 8th 05, 08:26 AM posted to microsoft.public.excel.misc
 Saxman Posts: n/a
Parsing Data

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

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

That works a treat! Many thanks.
#5
December 8th 05, 08:31 AM posted to microsoft.public.excel.misc
 Saxman Posts: n/a
Parsing Data

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

DataText to ColumnsDelimited by "Other".

Type in ( and Finish.

Gord Dibben Excel MVP

TU

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM Michael Excel Worksheet Functions 2 September 19th 05 05:36 PM Karl Burrows Excel Discussion (Misc queries) 4 May 3rd 05 01:06 AM Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM

All times are GMT +1. The time now is 08:15 PM.