Remove space and the letter after
I have a column with a list of names. Some name has first name, a space then middle initial and some has only the first name. See below example.
I'm trying to work a formula that take only the first name without the middle initial. I tried this =LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), but it show #invalid value on the one without initial.
Is there a formula that works all?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!