Excel 2003 Formulas ?

[Guest]

Excel 2003,
Hi,
After creating a formula to extract data from various cells to put into one
ie:
="Name: "&A2&", Surname: "&B2&", Age: "&C2

* I would like to delete the cells which I don't need anymore however I lose
data from the cell that I've applied the above formula to as it loses its ref
- is there a way around this ?

Thanks for your time to my query.
Regards,
MAC

 

[mphell0]

copy the cells with the name, surname, age. Go to edit->paste
special->values
and paste those cells into a new column. Delete the column with the
formula
and then you can delete any of the other cells that you need to.