Formulas
 

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?

Formulas
 

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?

Formulas
 

Thank you SO much. You have no idea how much time you just saved me!!

"dlw" wrote:

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?