hi
that would depend on the layout. it could involve using the "LEFT", "RIGHT",
and/or "MID" functons and may include other functions.
Post an 10 item example of your data.

regards
FSt1

"Lacey1941" wrote:

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?