concatenate keeping font

[kcmuppet]

Hi I've got a table with around 600 bar codes in column [Barcode] formatted using "Code 128" font corresponding to a part number in column [Part Number].

I'd like to be able to print them all with the part number under the barcode and so need to find a way to concatenate with a line return / char(10), while keeping the font, in a new column in the table.

Could this be done using a user defined function =keepformat([@[Barcode]]) & CHAR(10) & keepformat([@[Part Number]])?

Any help greatly appreciated.

 

[jasonb75]

A udf might be possible, although I think it would more likely be a procedure to set them directly to the cell (no in cell formula) but having the part number in the cell underneath the barcode would probably be more practical.

 

[kcmuppet]

...having the part number in the cell underneath the barcode would probably be more practical.

Yes, but how?

 

[jasonb75]

Hang on, when I read your question I think I may have incorrectly assumed that you were printing a selection of barcodes from a different part of the sheet. Am I right in what I now think, that you want them in another column of the same table?

 

[RoryA]

You can't do it with a formula (UDF has the same limitation). You could just use a macro.

 

[kcmuppet]

You could just use a macro.

Thanks - could you give me some clues for the code?

 

[kcmuppet]

Am I right ...you want them in another column of the same table?

Yes that would be simplest - then I could print the sheet with the label and stick the labels onto the parts boxes

 

[kcmuppet]

Well I didn't manage to figure out how to do this in excel so used this font instead, Fonts

...which achieves what I need by including the ASCII number under the bar code