New to all this, so please excuse the beginner question: I am building a small contact database and want to concatenate two address entries. As you might expect, I need a comma after the the first entry with a space following. The problem is that in most cases, there will not be a second address, i.e., that cell will be blank. If I add the comma by concatenating a comma and space between the two address entries, for example, =(b4&", "&g4), then the comma shows up whether there is a second address or not.
It seems like there should be a conditional statement that returns a comma and space plus the second address if there is a second address present, and returns nothing if the second address cell is blank. I can't find an easy way to do this. I can create a clumsy series of conditional statements like, "=CELL("type", address) followed by =IF(previous)="b", ", ", " "), and then concatenate some things together, but I can't quite get that work, either.
To summarize, is there a straightforward conditional statement that does what I'm looking for?
Bookmarks