Let's see if I understand.

A1: Anna
A2: Brian
A3: Chris

B1: =A1&" likes apples." <--Results in "Anna likes apples."
B2: =A2&" likes apples." <--Results in "Brian likes apples."
B3: =A3&" likes apples." <--Results in "Chris likes apples."


Is that what you're looking for?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=392210