jchewsmith
Technical User
I am trying to create a formula to concatenate 5 notes fields and each of these note field can be either NULL, blank or filled. When I try note1 & note2 & note3 & note4 & note 5 I get no results if any of these fields are NULL or blank.
Is there a formula to show a blank space if the field is null or blank but show the field if not for 5 fields in a row ?
Note1 = NULL
Note2 = Hello
Note3 = ""
Note4 = Ladies
Note5 = and gentlemen
Results:
Hello Ladies and gentlemen
Is there a formula to show a blank space if the field is null or blank but show the field if not for 5 fields in a row ?
Note1 = NULL
Note2 = Hello
Note3 = ""
Note4 = Ladies
Note5 = and gentlemen
Results:
Hello Ladies and gentlemen