In cells E2:E4 I have a string of text
I want a function that adds the character % after each string in each cell.
So in cell E2 I have the word Cat
In cell E3 Dog
In cell E4 Rat
I want the output in cell F1 to be Cat%Dog%Rat
I can do this fine with the below code however if there is a blank cell it will output as %Dog%Rat for example (if E2 is blank) rather than what I want which would be Dog%Rat
How do I adjust it so that if a cell is blank it ignores it rather than still adding the % symbol?
Please Login or Register to view this content.