CONCATENATE TWO DIFFERENT CELLS

R

RagDyeR

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!
=====================================================

Can I concatenate two different rows in a column?
 
C

cs_vision

Can I do it where a1 is the value used in each cell. ie.,

Column A
Bock, Sally
apple
pears

to: Bock, Sally apple
Bock, Sally pears
 
C

cs_vision

Neither, I just need the results looking to A1 as the repeating value, and
A2, A3, A4, etc, being concatenated with A1.
 
R

RagDyeR

Do you mean;
=A1&" "&A2
=A1&" "&A3
=A1&" "&A4
.... etc.
?
--

Regards,

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

Can I do it where a1 is the value used in each cell. ie.,

Column A
Bock, Sally
apple
pears

to: Bock, Sally apple
Bock, Sally pears
 
C

cs_vision

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
 
R

RagDyeR

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
 
Top