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 |
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 View this thread: http://www.excelforum.com/showthread...hreadid=491628 |
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 |
Parsing Data
On Wed, 7 Dec 2005 15:19:17 -0600, cvolkert wrote:
=LEFT(E3,FIND("(",E3)-1) That works a treat! Many thanks. |
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 |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com