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
I found that the dataset doesn't always contain the
- character, meaning there should be no change.