Hi

You could do something like this:
="for week "&E2&" ending"

Andy.

"Weasel" wrote in
message ...

In cell F2 of a sheet named "main flash" I want to have it display the
following:

"for week 42 ending"

The week 42 part would come from another sheet named "actuals" that's
in the same workbook.


--
Weasel
------------------------------------------------------------------------
Weasel's Profile:
http://www.excelforum.com/member.php...o&userid=27206
View this thread: http://www.excelforum.com/showthread...hreadid=525683