| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE TWO DIFFERENT CELLS
Can I concatenate two different rows in a column?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONCATENATE TWO DIFFERENT CELLS
=a1&a33
??? cs_vision wrote: Can I concatenate two different rows in a column? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| Use functions when cells are merged | Excel Worksheet Functions | |||
| Concatenate cells in Pocket Excel | Excel Discussion (Misc queries) | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
