ExcelBanter - CONCATENATE TWO DIFFERENT CELLS

ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CONCATENATE TWO DIFFERENT CELLS (https://www.excelbanter.com/excel-worksheet-functions/85668-concatenate-two-different-cells.html)

cs_vision

CONCATENATE TWO DIFFERENT CELLS

Can I concatenate two different rows in a column?

Dave Peterson

CONCATENATE TWO DIFFERENT CELLS

=a1&a33
???

cs_vision wrote:

Can I concatenate two different rows in a column?

--

Dave Peterson

RagDyeR

CONCATENATE TWO DIFFERENT CELLS

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?

cs_vision

CONCATENATE TWO DIFFERENT CELLS

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

"Dave Peterson" wrote:

=a1&a33
???

cs_vision wrote:

Can I concatenate two different rows in a column?

--

Dave Peterson

cs_vision

CONCATENATE TWO DIFFERENT CELLS

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?

RagDyeR

CONCATENATE TWO DIFFERENT CELLS

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

Regards,

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

"cs_vision" wrote in message
...
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

"Dave Peterson" wrote:

=a1&a33
???

cs_vision wrote:

Can I concatenate two different rows in a column?

--

Dave Peterson

RagDyeR

CONCATENATE TWO DIFFERENT CELLS

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?

cs_vision

CONCATENATE TWO DIFFERENT CELLS

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?

RagDyeR

CONCATENATE TWO DIFFERENT CELLS

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?

cs_vision

CONCATENATE TWO DIFFERENT CELLS

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

CONCATENATE TWO DIFFERENT CELLS

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

All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com