need help with a formula to remove everything to the right of " (" in a cell

[djs6025]

Hi Everybody,
Can you help with a formula to removed everything to the right of " (" in column A and put the results in cell B as shown below? Thanks so much for your help!

Thanks,
Dan

	A	B	C	D
1	154-150 (154-150 Digi Pro...	154-150
2	154-154 (154-154 Digi Pro...	154-154
3	154-158 (154-158 Digi Pro...	154-158
4

<tbody>
</tbody>

 

[sandy666]

try PowerQuery aka Get&Transform

raw		raw
154-150 (154-150 Digi Pro...		154-150
154-154 (154-154 Digi Pro...		154-154
154-158 (154-158 Digi Pro...		154-158

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Extract = Table.TransformColumns(Source, {{"raw", each Text.BeforeDelimiter(_, " ("), type text}})
in
    Extract[/SIZE]

 

[kweaver]

It's a simple formula using LEFT and FIND as:

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

If you have Excel 365, you can also put 154-150 in B1 and then use Flash Fill from the DATA ribbon.

 

[djs6025]

That worked! Thanks so much kweaver!