Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine cells under a common heading
I have a list of names and addresses but if two people live at the same
address they are listed separately. Is there a way to combine cells in which the cell to right is the same. example: [ John Smith] [123 Maple Ln] [ Jane Smith] [123 Maple Ln] becomes: [John Smith [123 Maple Ln] Jane Smith ] any help would be greatly apprecitated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine cells under a common heading
Hi,
You can do this by using a helper column next to the address columns, then hiding the column containing the addresses. If the first address is in B2, enter into C2: =IF(B2=B1,"",B2) This will return a blank value if the address above the one being tested is the same, or the address if it is not. Drag this formula down the entire list of addresses then hide the address column. Is this what you were after? Ewan. "Xhawk57" wrote: I have a list of names and addresses but if two people live at the same address they are listed separately. Is there a way to combine cells in which the cell to right is the same. example: [ John Smith] [123 Maple Ln] [ Jane Smith] [123 Maple Ln] becomes: [John Smith [123 Maple Ln] Jane Smith ] any help would be greatly apprecitated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine cells under a common heading
I am actually hoping to combine the two names in one cell separated by
alt+enter so that if: John Smith is in cell A1 and 123 Maple Ln is in cell B1 and Jane Smith is in cell A2 and 123 Maple Ln is in cell B2 i am looking for a formula or series of formulas that will put : John Smith <alt+enter Jane Smith in cell A1 (or C1 if nessesary) and leave 123 Maple ln in cell B1(or D2) while deleting it (or not including it) in row 2 Help?! "ewan7279" wrote: Hi, You can do this by using a helper column next to the address columns, then hiding the column containing the addresses. If the first address is in B2, enter into C2: =IF(B2=B1,"",B2) This will return a blank value if the address above the one being tested is the same, or the address if it is not. Drag this formula down the entire list of addresses then hide the address column. Is this what you were after? Ewan. "Xhawk57" wrote: I have a list of names and addresses but if two people live at the same address they are listed separately. Is there a way to combine cells in which the cell to right is the same. example: [ John Smith] [123 Maple Ln] [ Jane Smith] [123 Maple Ln] becomes: [John Smith [123 Maple Ln] Jane Smith ] any help would be greatly apprecitated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine cells by selecting range? | New Users to Excel | |||
Can I combine the text from multiple cells automatically | Excel Worksheet Functions | |||
seperating a group of common cells | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
How can I combine multiple cells in Excel? | Excel Discussion (Misc queries) |