Need to Split Names in Excel easily.Dont struggle with Customer formulas.User our standard Name Splitter Accordingly.

To Split Names to First ,Second and other Parameters use the formula =SPLIT.SPLITNAMES(B:B)
For Excel on Web (webview2) use the formula =SPLIT.SPLITNAMES(A1) and drag cell downwards

To Split Address to City ,State and other Parameters use the formula =SPLIT.SPLITADDRESS(B:B)
For Excel on Web (webview2) use the formula =SPLIT.SPLITADDRESS(A1) and drag cell downwards