ExcelBanter - Combining cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combining cells (https://www.excelbanter.com/excel-discussion-misc-queries/148036-combining-cells.html)

BAKERSMAN

Combining cells

I want to combine the data that is in 5 different cells into one cell. The
one cell that has all the information in it will be in the barcode format.

A1 B1 C1 D1
E1
LOT NUMBER DATE MACHINE # BATCH CODE PRODUCT #

C1
ALL CELLS COMBINED INTO ONE BARCODE

i HAVE THE BARCODE FONT LOADED TO MY COMPUTER.

Mike H

Combining cells

Will this work?

=(A1&B1&C1&D1&E1)

Mike

"BAKERSMAN" wrote:

I want to combine the data that is in 5 different cells into one cell. The
one cell that has all the information in it will be in the barcode format.

A1 B1 C1 D1
E1
LOT NUMBER DATE MACHINE # BATCH CODE PRODUCT #

C1
ALL CELLS COMBINED INTO ONE BARCODE

i HAVE THE BARCODE FONT LOADED TO MY COMPUTER.

Elkar

Combining cells

See if this works:

=A1 & B1 & C1 & D1 & E1

HTH,
Elkar

"BAKERSMAN" wrote:

I want to combine the data that is in 5 different cells into one cell. The
one cell that has all the information in it will be in the barcode format.

A1 B1 C1 D1
E1
LOT NUMBER DATE MACHINE # BATCH CODE PRODUCT #

C1
ALL CELLS COMBINED INTO ONE BARCODE

i HAVE THE BARCODE FONT LOADED TO MY COMPUTER.

All times are GMT +1. The time now is 08:15 AM.