I have a field that has data and I would like to create a new field that shows only the words before the dash. Is there a calculation I can write that will do this? Below are examples of the text:
Mary M. Knight-MC
Thanks for any help!