Hi all,
Hope you are well
I tried to concatenate with + if there are no data but getting errors
Limit 1 and Unit 1 will always have data
Limit 2 and Unit 2 might not always have data
If Limit 2 has no data, I don't want to show the "/"
Please could you assist?
Hope you are well
I tried to concatenate with + if there are no data but getting errors
Limit 1 and Unit 1 will always have data
Limit 2 and Unit 2 might not always have data
If Limit 2 has no data, I don't want to show the "/"
Please could you assist?
Limit: [Limit 1] & " " & [Unit 1] & " / " & [Limit 2] & " " & [Unit 2]