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

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

copy the cells contain the '=' formulae and paste/special as value to another
part of the worksheet. The text can then be editted in the copied cells.
--
Gary''s Student


"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