|
|
#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. 
|
|
|
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 7 64bit 
Office 2003
Threaded Mode