Excel Bar Code Formula Issues

Question

I copied a Google sheet into an Excel spreadsheet that contained bar codes and QR codes. The formula in Excel generates an error preventing the bar and QR codes to generate. It stated that the syntax is incorrect because of a 255-character limit. Is there a way around this?
Any assistance would be greatly appreciated.

Here is the code to generate Bar code copied from a Google Sheet:
=@IF(C2="","", image("http://generator.onbarcode.com/linear.aspx?TYPE=4&DATA="&C2&"&UOM=0&X=1&Y=20&LEFT-MARGIN=0&RIGHT-MARGIN=0&TOP-MARGIN=0&BOTTOM-MARGIN=0&RESOLUTION=72&ROTATE=0&BARCODE-WIDTH=0&BARCODE-HEIGHT=0&SHOW-TEXT=false&TEXT-FONT=Arial%7c9%7cRegular&TextMargin=6&FORMAT=gif&ADD-CHECK-SUM=false&I=1.0&N=2.0&SHOW-START-STOP-IN-TEXT"&"=true&PROCESS-TILDE=false"))

Here is the code to generate QR codes also copied from a Google sheet:
=@Gunjan ("https://www.cognex.com/api/Sitecore/Barcode/Get?data="&'Data input'!C2&"&code=Z_QR_CODE&width=300&imageType=JPG&foreColor=%23000000&backColor=%23FFFFFF&rotation=RotateNoneFlipNone")

Both have errors in Excel.

Answer 1

Hi @Rhashad West ,
Did you get the #NAME! error in Excel?
The IMAGE function is not available in Excel Workbook.

About Generate QR code in Excel, you can refer to this article:
https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.