I have a list of over 15,000 names in one column and I need a formula to
separate the surnames into one column and the first names into a second
column. I've done this before but have forgotten the formula. Can anyone
help me?