1 of 1 people found this helpful
If you want all characters up to the space before the first "-" that means you want the first 11 characters.
FIND([Column 2], "-") returns the position of the first "-" - i.e. 12.
So you just want:
LEFT([Column 2],FIND([Column 2],"-")-1)
Thanks Richard, that worked a treat but it also rows in column 2 where there are no dashes. Of course the calculation is returning blanks for this, I guess I need to test the presence of the character first. I shall give it a go!