Using Font Free 3 of 9 Extended to create barcode in Excel

Anfinsen

Board Regular
Joined
Apr 11, 2023
Messages
144
Office Version
  1. 365
Platform
  1. Windows
Good Morning All!

I am attempting to create a barcode in excel, using the free 3 of 9 extended font.

I am wanting to take the value in cell F6, then a carriage return, and then the value in cell G6. Where I am getting stuck is the carriage return. I think I am using the right characters, but it literally just encodes the $+M in the barcode, and not the carriage return. Does anyone have experience with this and could provide some assisatnve? I would greatly appreciate it!
Formula below, where I am having trouble with.

Excel Formula:
="*"&F6&"$+M"&G6&"*"
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Try it like
Excel Formula:
="*"&F6&CHAR(10)&G6&"*"
 
Upvote 0
Character 10 is a linefeed, as I don't have the font, I cannot test it.
 
Upvote 0
Solution

Forum statistics

Threads
1,223,573
Messages
6,173,138
Members
452,501
Latest member
musallam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top