mardi 6 octobre 2020

Is there a way to use an if statement in excel to return a person's name if it is 2 words vs. 3 words

enter image description here

Formula in column B: =LEFT(A2, FIND(" ", A2, FIND(" ", A2) + 1) - 1)

Formula in column C: =IF(B2<>"Null",B2,A2)

I want to be able to return the 2 word name in column C and am struggling to find how. Any tips?

Thank you in advance!

Aucun commentaire:

Enregistrer un commentaire