|
|
#1
11-02-2013, 04:11 PM
|
|||
|
|||
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
11-03-2013, 12:40 AM
|
|||
|
|||
|
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.
|
|
#4
11-03-2013, 11:22 AM
|
|||
|
|||
|
Quote:
|
|
|
|
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 |
Windows 8 
Office 2013
Linear Mode
