I have searched and searched for what I believe is really simple
formula, but either I dont know what to search for or what I want to do
is so elementary it should just be know. Anyway here is what I need to
do.

a1=tom
a2=smith
a3="that car belongs to ";a1;a2

I need this to be universal so the formula works on column 3 of any row
and will give me the result for that row.

Anybody have a link or suggestion

Carter


--
toad32
------------------------------------------------------------------------
toad32's Profile: http://www.excelforum.com/member.php...o&userid=24090
View this thread: http://www.excelforum.com/showthread...hreadid=376965