inserted commas, now need to separate

[Hoovdog]

I used this formula to insert a comma after the first text in a column (last name in this case), =REPLACE(C2,FIND(" ",C2),0,",") and worked like a charm. Now I need to separate the last name and first name in to two columns, but the column with the new commas is actually full of the formula (even though it shows the name with the comma in it), how do I get the results so I can do the split of first and last name?

 

[mvptomlinson]

Convert the column of formulas to values (copy cells, pastespecial > values), then use Text-to-Columns.

 

[Hoovdog]

just like that! thx!