| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining column content
Example: Column B contains "8305" and Column C contains "Route 53". How
can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
=B2&" "&C2 gives you
8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
I'm really dense. Al that comes up is#value! in Column D.
"Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
I have different numbers and addresses in the whole column. How doe you
combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
ok.. if you are looking at cells B2 and C2, and want them in D2:
=B2&C2 will combine the two cells together. Presumably, you want a space between the entered values, thus: =B2&" "&C2 Unless your B2 or C2 cell actually has a #VALUE in it, you should never get a #Value during a concatenate. Make sure you're using shift 7 for the &..... "Daphtg" wrote: I have different numbers and addresses in the whole column. How doe you combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
Thanks for your help your directions work wonderfully. However, how do I
combine the two columns with all their different content? I can't go one row at a time because I have thousands to do? Can you please help again!!! Two whole columns combined into one .. "Sean Timmons" wrote: ok.. if you are looking at cells B2 and C2, and want them in D2: =B2&C2 will combine the two cells together. Presumably, you want a space between the entered values, thus: =B2&" "&C2 Unless your B2 or C2 cell actually has a #VALUE in it, you should never get a #Value during a concatenate. Make sure you're using shift 7 for the &..... "Daphtg" wrote: I have different numbers and addresses in the whole column. How doe you combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
So, are you saying you want every single cell in column B in one cell? Or, do
you mean, you want to copy the formula to the bottom of your list? If the latter, just copy the fomrula as written and paste to the bottom. If the former, you can only concatenate up to 30 cells at once... "Daphtg" wrote: Thanks for your help your directions work wonderfully. However, how do I combine the two columns with all their different content? I can't go one row at a time because I have thousands to do? Can you please help again!!! Two whole columns combined into one . "Sean Timmons" wrote: ok.. if you are looking at cells B2 and C2, and want them in D2: =B2&C2 will combine the two cells together. Presumably, you want a space between the entered values, thus: =B2&" "&C2 Unless your B2 or C2 cell actually has a #VALUE in it, you should never get a #Value during a concatenate. Make sure you're using shift 7 for the &..... "Daphtg" wrote: I have different numbers and addresses in the whole column. How doe you combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
Enter the formula in D2
Double-click on the fill handle of D2 and the formula will be copied to end of data in column C Fill handle is the black square lump at lower right corner of the cell. Gord Dibben MS Excel MVP On Mon, 31 Aug 2009 13:41:02 -0700, Daphtg wrote: Thanks for your help your directions work wonderfully. However, how do I combine the two columns with all their different content? I can't go one row at a time because I have thousands to do? Can you please help again!!! Two whole columns combined into one . "Sean Timmons" wrote: ok.. if you are looking at cells B2 and C2, and want them in D2: =B2&C2 will combine the two cells together. Presumably, you want a space between the entered values, thus: =B2&" "&C2 Unless your B2 or C2 cell actually has a #VALUE in it, you should never get a #Value during a concatenate. Make sure you're using shift 7 for the &..... "Daphtg" wrote: I have different numbers and addresses in the whole column. How doe you combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combining column content
THANK YOU THANK YOU THANK YOU. So simple when you know what you're doing.
"Gord Dibben" wrote: Enter the formula in D2 Double-click on the fill handle of D2 and the formula will be copied to end of data in column C Fill handle is the black square lump at lower right corner of the cell. Gord Dibben MS Excel MVP On Mon, 31 Aug 2009 13:41:02 -0700, Daphtg wrote: Thanks for your help your directions work wonderfully. However, how do I combine the two columns with all their different content? I can't go one row at a time because I have thousands to do? Can you please help again!!! Two whole columns combined into one . "Sean Timmons" wrote: ok.. if you are looking at cells B2 and C2, and want them in D2: =B2&C2 will combine the two cells together. Presumably, you want a space between the entered values, thus: =B2&" "&C2 Unless your B2 or C2 cell actually has a #VALUE in it, you should never get a #Value during a concatenate. Make sure you're using shift 7 for the &..... "Daphtg" wrote: I have different numbers and addresses in the whole column. How doe you combine the entire contents of one column with the other.?? "Daphtg" wrote: I'm really dense. Al that comes up is#value! in Column D. "Sean Timmons" wrote: =B2&" "&C2 gives you 8305 Route 53 copy to bottom, past special/values if you want to get rid of B and C when done. "Daphtg" wrote: Example: Column B contains "8305" and Column C contains "Route 53". How can I combine the street number in Column B with the Street name in Column C and place the results in Column D? Text and Column obviously does no work. Have thousands of these to do. Thank you in advance am really up against it. Using 2004 on a MAC. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Content of two cells | Excel Discussion (Misc queries) | |||
| Update column H based upon content in column B | Excel Worksheet Functions | |||
| Combining Cell Content | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| Combining cell contents when there is content to combine | Excel Discussion (Misc queries) | |||
Linear Mode
