Hi everyone, I have an excel file that has 5 columns right now. I need to import them into Salesforce but the field I'm using has the values separated by a semi colon. Normally I would just do a formula like =A1&"; "&B1&"; "&C1&"; "&D1 etc.

The problem is that some cells have blank values in them, so I'd end up getting a result like:

FIBRE; ; COPPER

Are there any ways I can easily do this? I just basically want to take the 5 columns and join them together into 1 cell with the values separated by a semi colon. It's just the blank values that's throwing me off as some have a blank in the first column, some are blank in all but the last one, etc it's all random each one. Thanks!