Formulas

[Guest]

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?

 

[Guest]

copy / paste special / select Values

 

[Guest]

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