I separated mixed numeric and alphabetic date into two separate columns. However the data in the new columns remains the formula used for the separation and not the value of the data. How do I convert the new columns from the formula to the data the formula displays. I need to delete the original column to combine the worksheet into a master worksheet.
I lose the data in the new columns to a missing formula error when I try to delete the column with the mixed data.
45 Barclay Avenue
=REPLACE(Y4,1,FIND(" ",Y4),"") produces Barclay Avenue
=LEFT(Y11,FIND(" ",Y11)-1) produces 45