qr code generation

%3CLINGO-SUB%20id%3D%22lingo-sub-2912920%22%20slang%3D%22en-US%22%3Eqr%20code%20generation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2912920%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%20class%3D%22%22%3EDear%20all%2C%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20am%20trying%20to%20make%20a%20qr%20code%20in%20excel%20that%20is%20the%20result%20of%20a%20concat%20of%20other%20cells.%20The%20trouble%20is%20i%20get%20a%20qr%20code%20for%20each%20character.%20I%20have%20used%20QR4office%20and%20that%20works%20fine%2C%20but%20i%20want%20to%20do%20it%20myself.%20I%20have%20downloaded%20the%20QRtfb%20font%20and%20am%20using%20that%20to%20format%20the%20destination%20cell%20of%20the%20qr%20code.%20Can%20someone%20tell%20me%20how%20to%20change%20my%20group%20of%20qr%20codes%20into%20one%20code%20that%20represents%20the%20cells%20text.%3C%2FP%3E%3CP%20class%3D%22%22%3Ethanks%20in%20advance.%3C%2FP%3E%3CP%20class%3D%22%22%3EGraham%20Collett%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2912920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2913206%22%20slang%3D%22en-US%22%3ERe%3A%20qr%20code%20generation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2913206%22%20slang%3D%22en-US%22%3EA%20font%20-by%20definition-%20always%20works%20per%20character.%20This%20means%20you%20will%20never%20be%20able%20to%20generate%20a%20QR%20code%20of%20multiple%20characters%20using%20a%20Font.%3C%2FLINGO-BODY%3E
Occasional Visitor

Dear all,

I am trying to make a qr code in excel that is the result of a concat of other cells. The trouble is i get a qr code for each character. I have used QR4office and that works fine, but i want to do it myself. I have downloaded the QRtfb font and am using that to format the destination cell of the qr code. Can someone tell me how to change my group of qr codes into one code that represents the cells text.

thanks in advance.

Graham Collett

3 Replies
A font -by definition- always works per character. This means you will never be able to generate a QR code of multiple characters using a Font.
I have used it like this a year ago but don't remember the function to make the single qr code work. I thought someone else may know. There was a way of telling the cell to behave this way.

@Jan Karel PieterseI can understand your point now  ... it makes me now want to present the same question from the other point of view ... how can i make Excel present the cell's info to the font as a single peice of information rather than a bunch of characters joined together to make words.