I am looking for a way to extract a variable length substring from a string.
My cells will look something like:
ABC - DEF
ABCDE - DEF
ABCD - ABC
I want to split the string at the -
character, so the cells will become:
ABC
ABCDE
ABCD
This should be done with a formula and not VBScript.
I am using Excel 2010
EDIT
I found that the dataset doesn't always contain the -
character, meaning there should be no change.