Barcodes in Excel

[rodl66]

My spreadsheet has an employee ID in column A and their name in column B, I want to auto-generate a barcode in column C that includes data in each respective cell in A&B. I have the code 128 font installed and am using the following formula that is only pulling data from column A. I understand it is because I am not including column B, that is because I am not sure how to format it. I also want the cells in column C to be empty until data is in A & B.

Column C2 I have =IF(A2="","",IF(D2="","&A2&"))

Thank you in advance for assistance.

 

[iggydarsa]

Sounds like you need something like this:

=IF(OR(A2="", B2=""), "", A2&B2)

 

[rodl66]

Sounds like you need something like this:

=IF(OR(A2="", B2=""), "", A2&B2)

Thank you for the suggestion. I found out that if I force the barcode field to be blank, it removes the mandatory parts of the barcode that allows it to be read. I changed the font to the Code 39 and the formula to ="("&A2&"_"&B2&")" It's not exactly what I wanted, but will suffice. Thanks again!