Formula ? Need to pull first name only from other sheet?

[zone709]

='Time Sheet'!C8

So I use this and it will return Super - Local 14 right.

What I'm looking for it to only pull the first word Super.

Any help thanks.

 

[63falcondude]

This will work for the example that you shared

=LEFT('Time Sheet'!C8,FIND(" ",'Time Sheet'!C8)-1)

 

[zone709]

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

 

[63falcondude]

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

The formula that I posted returns everything to the left of the first space. If there is no space, the formula will not work. Can C8 be anything other than "Super -..." or "Super"? If so, you will have to share some more examples so that we can make the formula more robust.

If those are the only two instances, try the following.

=IFERROR(LEFT('Time Sheet'!C8,FIND(" ",'Time Sheet'!C8)-1),"Super")

 

[zone709]

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.

 

[63falcondude]

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.

In that case, try

=IFERROR(LEFT('Time Sheet'!C8,FIND(" ",'Time Sheet'!C8)-1),'Time Sheet'!C8)

 

[zone709]

That wroks perfect thanks.

 

[63falcondude]

That wroks perfect thanks.

Great! Glad to help.