I need help joining several cells together and adding dashes inbetween each cells information.
The problem is that some cells have no information. What I am ending up with right now is this:
scattered throughout/ALL flew all directions/ / / /
because the last four cells have no information.
So I am assuming I have to determine in my formula if the cell is blank. I was thinking of this:
=IF(K5="",L5, . . . . . I'm not sure what!!!
Anyway, your help is GREATLY appreciated.