Perfect only issue I ran into if the cell has one word. It wont work and return #Value. Can we add something in there to recognize both. If Super alone. Return Super and if Super - Local 14 or whatever etcccc retun First word Super?
Thanks
Hi yeah its gonna be all different names so examples I can run into these examples below. I need though to pull in first name only regardless if the name is alone or with anything. Examples
Super = Super
Super Local 14 = Super
Carpenter - Local 15 = Carpenter
Cement Foremen = Cement
So the first formula works fine. I just need it to work also its the word is alone like one word.
That wroks perfect thanks.