Need help on Code128 and Excel (carriage return and pipe)

[pohboonsiang]

I was trying to convert the below string to code128 barcode with human readable text. I used excel function code128ex but could not find the appropriate font type to display both barcode and readable text. The input string contains carriage return (~d013) and pipe ("|").

Input text: |338015391501~d013110110003764011~d0131010~d013088000
If use font MRV Code128M, it will only show me the barcode without text.
If use font MRV Code128cMa, it will show me the barcode with text "9299338015391501 77179910110003764011 77991010 779908800005" instead of "|338015391501 110110003764011 1010 088000".

Please help. Thanks.

[glitch]

When you are doing mixed Code128 character set, you can't get the human readable displayed correctly using the font, because the font can't alter its characters dynamically. You will get the correct result from the barcode.

To work around the problem, you can use the cell below for human readable text.

Or you can use Barcode ActiveX control (http://www.morovia.com/activex/barcode-lite.asp), which fits better in your scenario.

[pohboonsiang]

Thanks for the replies. I will use cell below to display human readable text.

[043turning]

I posted this question in another post but closer inspection I see that last date it was used was 2007 so I thought it might be better to post here ....

Hi Guys/Gals, Sorry my first post is a question but I am new to the barcode world and whilst I understand the need to handshaking Error corection and data integaty the software I'm using requires a "Tab"to be inserted at the end of the Data and Whilst I can find many ASCI table that show the code for functions like tab very few barcode generatos allow for the addition of special charators.
I guess my question is can you create a dta field like "19_SQR124-4L"and have a "TAB" included in the string using XLS =Code128A(C2)

[glitch]

You can use CONCATENATE function in Excel to combine fields:

Code128A( CONCATENATE("19_SQR124-4L", Chr(9), C2) )

[glitch]

I also recommend to use Code128Ex function, instead of Code128A. The former one will produce shorter barcode.

http://mdn.morovia.com/kb/entry/10048/I ... -EAN128Ex/