In a worksheet at work they have listed the last name then the first name in one cell. They did not use commas to seperate the names, just a space, Is there an easy way to split the last name off into one cell and then the first name into another? I really want to be able to have first and last names into seperate cells. Thaks, Larry

Ok here's a work around cut and paste into word as plain text then select it and then table > convert > text to table > separate text at > other and type in a space. Your text will then be seperated out in a table, you can then select all the first names and copy and paste back into excel (and do the same with the second names as well) Techy n Welsh

Another method is to insert two columns and use text string functions to split at the first space. Then remove the formulas by copying the two columns and use paste special values only. If the operations are successful then delete the original name column.

Both great ideas! Thanks. I'll fix this file yet! Larry

It looks like a lot of words in it's explanation but it is not really. See MS article for "Separating Names". Regards, Bryan

Bryan, You always come up with most elegant solutions! Larry

Thank you Larry. I really liked that article because it introduced me to a few functions that I would, otherwise, had never known about. Bryan