G
Guest
Can I concatenate two different rows in a column?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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?
=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?
G
Guest
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
Column A
Bock, Sally
apple
pears
to: Bock, Sally apple
Bock, Sally pears
G
Guest
Neither, I just need the results looking to A1 as the repeating value, and
A2, A3, A4, etc, being concatenated with A1.
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
=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
R
RagDyeR
Try,
=A1&" Apples"
=A1&" Pears"
=A1&" Peaches"
=A1&" Apples"
=A1&" Pears"
=A1&" Peaches"
G
Guest
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
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
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
G
Guest
YES! Thank you one more thing, how do I copy and keep the concatenated text?
D
Dave Peterson
edit|copy
go to the new range
edit|paste special|values
go to the new range
edit|paste special|values
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.