| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Combine two or more columns by using a function
Hello,
I have combine 3 columns using the concatenate function and used CHAR(10) to insert a new line for each column. Here's my example: A1: 100 Main Street B1: Suite 12 C1: Washington, DC 20016 D1: ? So in D1, I created a function =Concatenate(A1, CHAR(10), B1, CHAR(10), C1) and the result is perfect! 100 Main Street Suite 12 Washington, DC 20016 My problem is when B1 column doesn't have any data, I want Excel to eliminate the blank line. How can I get it to work? I'm lost at this point Please help, Thanks! |
|
#2
|
|||
|
|||
|
Combine two or more columns by using a function
try this:
=IF(OR(B1="",B1=0),CONCATENATE(A1,CHAR(10),C1),CON CATENATE(A1, CHAR(10), B1, CHAR(10), C1)) "Bagia" wrote: Hello, I have combine 3 columns using the concatenate function and used CHAR(10) to insert a new line for each column. Here's my example: A1: 100 Main Street B1: Suite 12 C1: Washington, DC 20016 D1: ? So in D1, I created a function =Concatenate(A1, CHAR(10), B1, CHAR(10), C1) and the result is perfect! 100 Main Street Suite 12 Washington, DC 20016 My problem is when B1 column doesn't have any data, I want Excel to eliminate the blank line. How can I get it to work? I'm lost at this point Please help, Thanks! |
|
#3
|
|||
|
|||
|
Combine two or more columns by using a function
Thank you so much Nikki!
"Nikki" wrote: try this: =IF(OR(B1="",B1=0),CONCATENATE(A1,CHAR(10),C1),CON CATENATE(A1, CHAR(10), B1, CHAR(10), C1)) "Bagia" wrote: Hello, I have combine 3 columns using the concatenate function and used CHAR(10) to insert a new line for each column. Here's my example: A1: 100 Main Street B1: Suite 12 C1: Washington, DC 20016 D1: ? So in D1, I created a function =Concatenate(A1, CHAR(10), B1, CHAR(10), C1) and the result is perfect! 100 Main Street Suite 12 Washington, DC 20016 My problem is when B1 column doesn't have any data, I want Excel to eliminate the blank line. How can I get it to work? I'm lost at this point Please help, Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a function to auto-sort 2 columns? | Excel Worksheet Functions | |||
| how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| How to combine Hyperlink with Lookup function? | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hybrid Mode
