I'd like to split the content of a cell to an adjacent cell. For instance in
column B there is a list of first name and last name; all found within a
cell. I'd like to split the content so that the first name remains in column
B and the last name is pasted onto column C.

Thanks,