I want to combine cells into one address block, but if there are no addresses I want the cell to remain blank. I'm having trouble creating this. Right now I'm getting a random common in the box: This is the formula I'm using: CONCATENATE({Address 1} ...
That worked for getting it to turn blue again, but still gave me an error. Thank you so much for being willing to help. I'm just awful at this. I still need the complete address to show up if there is an address entered. I just need the cell to be bl...
Thank you; however, it's still giving me an error:I'm just trying to get rid of those pesky commas in the address complete box if those other boxes are empty.
I am having a similar issue. I'm having commas show up when I don't want them to show up if the fields are empty.I'm trying to use this formula which randomly used to work: CONCATENATE({Address 1} & "\n" & IF({Address 2}, {Address 2} & "\n") & {Addre...
