Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns
how do you combine column content as in number in address and street name?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns
Do you think "Concatenate" or "&" helps?
Daphtg wrote: how do you combine column content as in number in address and street name? -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns
You can combine text (know as concatenating) from two cells (A1 and B1 for
this example) like this... =A1&" "&B1 Notice concatenated a space in between the text from these two cells in order to separate them. If you leave that out... =A1&B1 the text from the two cells will butt up against each other. You can concatenate multiple cell values and text constants in any order you want. -- Rick (MVP - Excel) "Daphtg" wrote in message ... how do you combine column content as in number in address and street name? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns
Hi,
=A1&", "&B1 This would concatenate the contents of A1 and B1 in a new cell with a comma and a space between them. There are few if any reasons to use the CONCATENATION function instead of &. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Daphtg" wrote: how do you combine column content as in number in address and street name? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
columns
=A1 & " " & B1 &" " & C1
Gord Dibben MS Excel MVP On Mon, 31 Aug 2009 12:00:01 -0700, Daphtg wrote: how do you combine column content as in number in address and street name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Columns A&B on Sheet2 always equal Sheet1 table columns A&B | Excel Worksheet Functions | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |