Query String to pre-fill a form

I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space.

=JOIN([Join Column]@row:DlrName@row, "&DlrName=")

results with a query string but only the first word in the column DlrName. How do I add all the words in the column including the spaces. A Dlrname might be "Good Dealer Inc." and I want the full name so that my query string will pre-fill the full name in my form.


Best Answer