Hello!

If you want to concatenate with spaces, you can:

=A1&" "&B1&" "C1

So in this case, you just added 5 spaces in between A1 and B1, and just 1 space between B1 and C1. same principles apply for all other situations. It just depends on how many spaces you need in between.

I learned a lot about Combining cells together he
https://www.efinancialmodels.com/kno...se-2-formulas/


Hope this helps!