=_xlfn.TEXTBEFORE(A47, ".")
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!