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