I'm mucking around and have succeeded in concatenating two fields but I would like a space between them. A space does not want to work when inserted in the formula. How do you customize a concatenation with spaces, commas etc.?
I'm mucking around and have succeeded in concatenating two fields but I would like a space between them. A space does not want to work when inserted in the formula. How do you customize a concatenation with spaces, commas etc.?
To concatenate A1 and B1 with a space between....
=A1&" "&B1
or comma then space
=A1&", "&B1
That was too easy!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks