Barcodes in Excel

HappyChappy

Active Member
Joined
Jan 26, 2013
Messages
383
Office Version
  1. 2019
  2. 2010
  3. 2007
Platform
  1. Windows
Hi having great problems with bar codes currently using a web based site https://www.barcodesinc.com/generator/index.php to generate barcodes then cutting and pasting them into excel as a picture. The site uses Code 128b for the fonts.
I downloaded said font and thought it must be better to do it myself but the latter part of the barcode seems to be different from my down loaded picture. i'm using the formula ="*"&A28&"*"
for the life of me i cant see why it's different any help on this please.
a typical barcode would be 973415748
 
BarCodeV2.0.xlsm
ABCDEFGHIJ
1Order Processing
2Route/Drop
3
4Date:Awaiting Rebook:
5
6Order No:Awaiting Cancellation:
7
8Customer Name:Rebooked:
9
10Postcode:Cancelled:
11
12Qty of Items:Instant Return:
13
14Qty of SLEDGES:
15
16Processed By:
17
18Re Book Date if required:
19
201st Attempt to rebook DeliveryAttempted By:
21
222nd Attempt to rebook DeliveryAttempted By:
23
243rd Attempt to rebook DeliveryAttempted By:
25
26Comments:
27973467890Ì973467890JÎ
28
29
Barcode


try this
 
Upvote 0

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

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