You can either use
=A1&"additional text"
to add text to the end,
or you can Copy the cell and Paste Special - Value back over itsself.

You can then edit that text, however, any change to the text in the
original copied cell will no longer reflect in this (edited) cell.




Jonny Wrote:
I have a large database set up for my company to create cost sheets and
quotations etc.

the quotations basically copy whatever is in the cost sheet using the
"=".

Is there any way I can edit this text once it has been copied into
here?

I would appeciate any help on the matter.

Thanks very much,

Jonathan


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=481803