how to find value of a cell to the left of the dash with unknown characters

kjenkins

I want to pull the value to the left of the dash HELP PLEASE

Andrée Starå

Hi @kjenkins

I hope you're well and safe!

Will it always be 6 numbers?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

kjenkins

@Andrée Starå No it is various characters

Andrée Starå

@kjenkins

Try something like this.

=LEFT([Sku-Description]@row, FIND("-", [Sku-Description]@row) - 1)

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!