Excel formula help please

[getafix33]

Hi

I am trying to create a barcode using information from two different cells.

I use the CHAR function to take the info from one cell, add a return carriage and input the info from the 2nd cell.

However, when I covert the text to a barcode, it displays two seperate barcodes (one for each cell info).

In the example, I would like to have a barcode and under it displayed 1234567890 and below that username

Is it possible to have one barcode with text from each cell displayed under it?

 

[WAslayer]

I don't have the solution, but your likely issue is the return carriage..

 

[RunningFromFat]

Ask chatgpt

 

[saor]

Hi

I am trying to create a barcode using information from two different cells.

I use the CHAR function to take the info from one cell, add a return carriage and input the info from the 2nd cell.

However, when I covert the text to a barcode, it displays two seperate barcodes (one for each cell info).

In the example, I would like to have a barcode and under it displayed 1234567890 and below that username

Is it possible to have one barcode with text from each cell displayed under it?

Do you need the code and the details in the same cell?

 

[rh1]

Hi

I am trying to create a barcode using information from two different cells.

I use the CHAR function to take the info from one cell, add a return carriage and input the info from the 2nd cell.

However, when I covert the text to a barcode, it displays two seperate barcodes (one for each cell info).

In the example, I would like to have a barcode and under it displayed 1234567890 and below that username

Is it possible to have one barcode with text from each cell displayed under it?

Would concatenate not help as the return carriage may be the reason its misintepreting that it must be two barcodes?

 

[getafix33]

Do you need the code and the details in the same cell?

Hi, yes I do.

Regards

 

[Pegging]

Have you tried to concactenate?

Adding carriage return is explained here.

Redirecting

 

[rh1]

 

[rh1]

At work so not going to get the barcode font.

 

[Pegging]

View attachment 1823698

Don’t look like a beginner.

Use the & sign instead of typing it out.

 

[rh1]

Don’t look like a beginner.

Use the & sign instead of typing it out.

View attachment 1823699

I have been using it for years, lol.

Guess I am an old beginner, thanks for the tip.

 

[rh1]

Don’t look like a beginner.

Use the & sign instead of typing it out.

View attachment 1823699

I was going to ask how to get a spacing but =A1 & " " & B1 gave me the spacing.

 

[Pegging]

I was going to ask how to get a spacing but =A1 & " " & B1 gave me the spacing.

Carriage return is Alt and Enter. It get you to the next line in a cell.

 

[rh1]

Carriage return is Alt and Enter. It get you to the next line in a cell.

That one I know. I meant to get a space between the joining of two cells content.

 

[getafix33]

This is the function I used.

Tried the CONCENCATE with " " and I still get two separate barcodes

 

[Pegging]

That one I know. I meant to get a space between the joining of two cells content.

I’ve never used “carriage return” in an Excel function before, never needed it.

 

[rh1]

This is the function I used.

Tried the CONCENCATE with " " and I still get two separate barcodes

You know the forum rules, post pics of the excel sheet/formula, not your nudes.

 

[Pegging]

Hi

I am trying to create a barcode using information from two different cells.

I use the CHAR function to take the info from one cell, add a return carriage and input the info from the 2nd cell.

However, when I covert the text to a barcode, it displays two seperate barcodes (one for each cell info).

In the example, I would like to have a barcode and under it displayed 1234567890 and below that username

Is it possible to have one barcode with text from each cell displayed under it?

What are you using to convert to a barcode?
Are you changing the font?

 

[getafix33]

What are you using to convert to a barcode?
Are you changing the font?

Hi, Yes that is correct,

 

[rh1]

This is the function I used.

Tried the CONCENCATE with " " and I still get two separate barcodes

Dont create the space, make one word.