Thread
:
Join cells together separated by ; when some are blank
View Single Post
11-03-2013, 12:40 AM
excelledsoftware
Windows 7 64bit
Office 2003
IT Specialist
Join Date: Jan 2012
Location: Utah
Posts: 455
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.
excelledsoftware
View Public Profile
Find all posts by excelledsoftware