tony h Wrote:
="p"&C8&"-1" where c8 is the cell reference

thank you, I typed that in and all it displayed was exactly what you
typed. so it actually displayed ="p"&b1&"-1" and not p(variable)-1
like I had hoped


I am an excel noob, do I have to format the cell a certain way. Thanks
for your help


--
clrwtrms
------------------------------------------------------------------------
clrwtrms's Profile: http://www.excelforum.com/member.php...o&userid=29703
View this thread: http://www.excelforum.com/showthread...hreadid=494154