I have a simple question about generating QR codes with google-spreadhseet. I am using google's API call
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&A3)
This works fine.
Where A3
is a persons first name.
I have their last name in A4
but when I try:
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&(A3+A4))
or
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl="&
(CONCATENATE(A3, " ", A4)))
The QR box is blank.
How can I generate a QR code from both the first and last name without having to create another field.