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


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]154-150 (154-150 Digi Pro...[/TD]
[TD]154-150[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]154-154 (154-154 Digi Pro...[/TD]
[TD]154-154[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]154-158 (154-158 Digi Pro...[/TD]
[TD]154-158[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

try PowerQuery aka Get&Transform

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]raw[/td][td][/td][td=bgcolor:#70AD47]raw[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]154-150 (154-150 Digi Pro...[/td][td][/td][td=bgcolor:#E2EFDA]154-150[/td][/tr]

[tr=bgcolor:#FFFFFF][td]154-154 (154-154 Digi Pro...[/td][td][/td][td]154-154[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]154-158 (154-158 Digi Pro...[/td][td][/td][td=bgcolor:#E2EFDA]154-158[/td][/tr]
[/table]

[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!