Merging cells "only if" second cell is populated
I need to merge info from two Excel columns into one. Know how to do that. But, I need to insert a semicolon between info from each column "only if" the second column has info. Not all second columns will be populated when the merge is conducted. I don't want to end up with "info:nothing." Want to have "info:info" only when it applies. Does that make sense?
Microsoft OfficeMicrosoft Excel
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.