Remove/Replace Mark parenthesis (...)

[muhammad susanto]

hi all...

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

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]data[/td][td]after formula[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td]text (aaaa aaa bbbbb)[/td][td]text[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td]text (aaa bbb cccccccccc)[/td][td]text[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td]text (aa ddd eeeeeeeeeeeeee)[/td][td]text[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

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)