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)

To Split Address to City ,State and other Parameters use the formula =SPLIT.SPLITADDRESS(B:B)