This was a very helpful explanation...my only problem is in separating first names and middle initials some have initials and some do not and it pops in #value. To further complicate it the list has items like H William Jones and Richard L Smith. So still lost.
@Mostly-harmless-human
5 жыл бұрын
You could do something like, IFERROR(LEFT(A3,FIND(" ",A3))&LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3)),2),LEFT(A3,FIND(" ",A3))). I use nested functions like these frequently. Add one more IFERROR() function if you just want to return a null value for any additional errors.
@ruhichorasiya
6 жыл бұрын
Ashvin mohanlal Chorasiya how to create ashvin Chorasiya mohanlal is my father name
@mrpink7831
4 жыл бұрын
thanks you for this, may I also ask how to do your formula if we there is 2 first name?
@landmark4928
Жыл бұрын
On medical app asking for photo of medi cal can you put first name -middle,beneficiary:surname
@nikkomoto53
6 жыл бұрын
tnx for this tutorial :)
@DrGrande
6 жыл бұрын
You're welcome!
@sll1174
2 жыл бұрын
Awesome! Thank you for posting this tutorial video. Solved my questions. Big thanks, Todd!!!
@sandipbhand7348
4 жыл бұрын
Thanks
@lightaccentsDW
5 жыл бұрын
You Are Awesome!! Thank you. ( I had some names with middle initials and some without so I modified the last name function to this "=RIGHT(A1,LEN(A1)-FIND(" ",A1)+1)"
Пікірлер: 11