Editing Repeated Text

J

Jonny

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
 
B

Bryan Hessey

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.
 
G

Gary''s Student

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.
 
Top