I need help with this formula, i've spend WAY too much time on it
I am trying to extract names from a contact list, some have periods, some just one name some have multiple names. I'm trying to extract them so it says F. Jones or F.B. Jones or B G Jones
when i use the formula i have, it works for names with a period, but the other ones it gives the entire first name.. help!
the blank columns i would like to say F. Jones or F.B Jones, or F L Jones
Help Article Resources
Check out the Formula Handbook template!