Combine two functions CONCAT and LOWER with Substitute

I would like to Concatenate [CustomerID] and [SiteID] in my APP and Lower the letters and user substitute to put everything together without spaces.
The final result would be like: customernorthoffice.

Iโ€™ve tried to combine them all but no luck. Appreciate your help.

0 4 470
4 REPLIES 4
Top Labels in this Space