Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
The SEARCH function and parsing data | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |