Skip to content

Instantly share code, notes, and snippets.

@discarn8

discarn8/EXCEL_FORMULA_Convert_first_dot_last.vba

Last active May 3, 2018 21:27
Show Gist options
  • Save discarn8/23c30e46d676cb4641a38de14236f339 to your computer and use it in GitHub Desktop.
Save discarn8/23c30e46d676cb4641a38de14236f339 to your computer and use it in GitHub Desktop.
Download ZIP
EXCEL_FORMULA_Convert_first_dot_last
Raw
EXCEL_FORMULA_Convert_first_dot_last.vba
last.first
=LOWER(IF(LEN(A12)=0,"",IF(ISERR(FIND(" ",A12)),A12,LEFT(A12,FIND(" ",A12)-2)))&"."&MID(A12,SEARCH(", ",A12)+2, SEARCH(" ",MID(A12&" ", SEARCH(", ",A12)+4,200))+1)))))
first.last
=LOWER(MID(A14,SEARCH(", ",A14)+2, SEARCH(" ",MID(A14&" ", SEARCH(", ",A14)+4,200))+1)&"."&IF(LEN(A14)=0,"",IF(ISERR(FIND(" ",A14)),A14,LEFT(A14,FIND(" ",A14)-2))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment