I have one cell which contains the first and last name separated by a space.
I want to change this into two separate cells. The names are all different
lengths. I am unable to find any command to do this. Sort of a backwards
concatenate. Does anyone know how to do this?