split first and last names

Suppose you have a list of names in your data records separated by a space, now want to separate first and last names into two columns. Microsoft Excel allows to spilled a single cell…