Try,
=A1&" Apples"
=A1&" Pears"
=A1&" Peaches"
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


"cs_vision" wrote in message
...
Neither, I just need the results looking to A1 as the repeating value, and
A2, A3, A4, etc, being concatenated with A1.

"RagDyeR" wrote:

Do you mean in a *third* cell?

=A1&A2

Or, with a space between:
=A1&" "&A2

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"cs_vision" wrote in message
...
Can I concatenate two different rows in a column?