I have the following formula that produces a barcode when used with a "3 of 9" font:
=IF(ISBLANK(B23),"","*"&B23&"*"), it is looking at a string of character in lowercase but when printed out it produces an uppercase string which won't work. It is used with a barcode scanner. When I remove the "*" from the formula on both sides of the cell reference the scanner doesn't recognize the output. Any suggestions?
=IF(ISBLANK(B23),"","*"&B23&"*"), it is looking at a string of character in lowercase but when printed out it produces an uppercase string which won't work. It is used with a barcode scanner. When I remove the "*" from the formula on both sides of the cell reference the scanner doesn't recognize the output. Any suggestions?