copy / paste special / select Values

"Dreyah" wrote:

I'm thinking the chances of this are slim to none, but here goes...

I have 4 columns in an excel spreadsheet. The first 3 contain values. The
last column I have written a concatenation formula to combine the first 3
columns. Is there a way to lock in the actual data that is in column 4 so
that I can delete columns 1-3 when its complete and not get the REF# error.
I understand that the formula is reading columns 1-3 in order to know what to
do, but I want to somehow convert the cell from the formula to the actual
concatenated value...so that the reference cells can be deleted.

Does anyone know if this is possible?