Can I retain a formula in the cell pasted to?

E

Earl

Is there a way to retain a formula in column (3) (Proj. No. under
'Comparison') below while performing cut/paste?

If so, what would the formula be to place an asterisk on each side of the
data if it is not equal to the data in column (1) ?



Original Comparison
Proj. No. Proj. Desc. Proj. No. Proj. Desc.
02-03 xxxxx ???? ?????
02-14 yyyyyy
03-23 zzzzzz

TIA

Earl
 
B

Bob Phillips

You cannot have a formula and a separate value in the same cell, you need to
use more cells.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top