#1
|
|||
|
|||
Join cells together separated by ; when some are blank
Hi everyone, I have an excel file that has 5 columns right now. I need to import them into Salesforce but the field I'm using has the values separated by a semi colon. Normally I would just do a formula like =A1&"; "&B1&"; "&C1&"; "&D1 etc.
The problem is that some cells have blank values in them, so I'd end up getting a result like: FIBRE; ; COPPER Are there any ways I can easily do this? I just basically want to take the 5 columns and join them together into 1 cell with the values separated by a semi colon. It's just the blank values that's throwing me off as some have a blank in the first column, some are blank in all but the last one, etc it's all random each one. Thanks! |
#2
|
|||
|
|||
You could try an if statement. instead of =A1&"; " use if(A1="","",a1&"; ")
This will look if the cell has nothing. If it has nothing, nothing will be returned, otherwise your semicolon formula like normal will be displayed. |
#3
|
|||
|
|||
Awesome that worked perfectly thanks so much!
|
#4
|
|||
|
|||
You are very welcome!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to segregate a single record into separated cells | KIM SOLIS | Excel | 3 | 09-09-2011 02:54 AM |
Selecting blank cells in criteria | apolloman | Excel | 6 | 08-24-2011 05:38 AM |
How to organize and insert blank cells between a huge number of data? | tareq | Excel | 12 | 09-29-2010 02:12 PM |
adding text on a separated column line | ahmet1985 | Word | 0 | 03-27-2010 07:10 AM |
Using both drop down lists and blank cells for text | voltarei | Word | 0 | 03-18-2010 04:16 AM |