Remove/Replace Mark parenthesis (...)

[muhammad susanto]

hi all...

i have table layout ...
how to replace/remove after mark parenthesis (....)

Excel 2007 32 bit

	D​	E​
4​	data	after formula
5​	text (aaaa aaa bbbbb)	text
6​	text (aaa bbb cccccccccc)	text
7​	text (aa ddd eeeeeeeeeeeeee)	text

Sheet: Sheet1

any assistance...much appreciated..

m.susanto

 

[hiker95]

muhammad susanto,

In cell E5 enter the following formula: =LEFT(D5,FIND(" (",D5)-1)

And, copy it down.

 

[FDibbins]

Try this...
E5=LEFT(d5,FIND("(",d5)-2)
copied down

 

[Drrellik]

=left(a1,find("(",a1)-1)