AFTER I Combine Two Columns Into One ...

Hello:

After combining two columns (First Name, Last Name) into one column (NAME), how do I delete the original two columns (First Name, Last Name) without losing the data in the new column (NAME)?

When I delete the first two columns all the combined names are replaced with =#REF!&" "&#REF!

Thanks

Michael