edit|copy
go to the new range
edit|paste special|values



cs_vision wrote:

YES! Thank you one more thing, how do I copy and keep the concatenated text?

"RagDyeR" wrote:

Is this what you mean?

This can be copied down:

=$A$1&" "&A2

Where A1 is an absolute reference and when copied down produces:

=$A$1&" "&A3
=$A$1&" "&A4
=$A$1&" "&A5
--

Regards,

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

"cs_vision" wrote in message
...
I'm so sorry, what I am trying to do is copy the formula, but keep the first
variable A1. I have a large spreadsheet where A1 needs to be concatenated
with other cells

"RagDyeR" wrote:

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?










--

Dave Peterson