View Single Post
 
Old 11-03-2013, 12:40 AM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote