Excel formula help please

[getafix33]

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

As requested.

Thanks for the help.

 

[Pegging]

Hi, Yes that is correct,

Maybe try applying two different fonts to the cell.
That is why you see two barcodes.

You could try paste values over the cells, that will remove the formula, and then change the font for the username.
I don’t have Excel with me right now so can’t test.

apply multiple font colors or fonts in one cell - Microsoft Q&A

apply multiple font colors or fonts in one cell. Example : Hello, my name is Pierre "Pierre" would be in red "Hello, my name is" would be in black And not a formula. I used to be able, but sometimes I can. Anybody knows? I saw only…

answers.microsoft.com

 

[getafix33]

Dont create the space, make one word.

Unforunately i don't get the desired result.

 

[rh1]

Unforunately i don't get the desired result.

Remove the"" and one ,

 

[saor]

Maybe try applying two different fonts to the cell.

Don't think you can, at least not in Sheets.

 

[saor]

Hi, yes I do.

Regards

Is it really that important to have it in the same cells? You can format the two cells to look like one with borders etc.

 

[Pegging]

Maybe try applying two different fonts to the cell.
That is why you see two barcodes.

You could try paste values over the cells, that will remove the formula, and then change the font for the username.
I don’t have Excel with me right now so can’t test.

apply multiple font colors or fonts in one cell - Microsoft Q&A

apply multiple font colors or fonts in one cell. Example : Hello, my name is Pierre "Pierre" would be in red "Hello, my name is" would be in black And not a formula. I used to be able, but sometimes I can. Anybody knows? I saw only…

answers.microsoft.com

Using the method I mention above I can get both in a cell.

You have to value copy the cell though.

 

[rh1]

At home, downloaded the font:





Font used: https://www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font

 

[rh1]

Using the method I mention above I can get both in a cell.

You have to value copy the cell though.

View attachment 1823730

Got it working above, no copying of values. And yes, I used the old Concatenate formula

 

[Pegging]

At home, downloaded the font:
View attachment 1823766


View attachment 1823767

Font used: https://www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font

I used this one.
I see there are many types

Libre Barcode 128 - Google Fonts

Libre Barcode fonts enable you to write barcodes in the Code 39, Code 128 and EAN-13/UPC-12 formats, with or without text below the code. A number of fonts are

fonts.google.com

 

[getafix33]

At home, downloaded the font:
View attachment 1823766


View attachment 1823767

Font used: https://www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font

Hi. Thanks so much for your help. I am able to get the same as you but what I’m after as per your example is Piet under 1234567890 but with one code

 

[Sagax]

I take it that you are looking for something like this?


It can be achieved by adding a text box (located on "Insert" banner) below the bar code.

Select text box then press F2 to edit it in the formula bar. Refence your username cell (=A2 in this example) and press enter.
Move and resize the text box to where you want the text positioned inside the cell. (do this before replicating the section)
Format the shape and choose no fill and no border line.
To replicate, select all the cells with the data (A2 - C2 in this example), copy it and then paste below each other. The text box will replicate along with the selected cells that is being pasted.
Unfortunately you will have to change the username reference in each text box for every row since that information doesn't update dynamically, so it will involve additional upfront work to be done when setting up the template.

 

[rh1]

I take it that you are looking for something like this?
View attachment 1823833

It can be achieved by adding a text box (located on "Insert" banner) below the bar code. View attachment 1823840

Select text box then press F2 to edit it in the formula bar. Refence your username cell (=A2 in this example) and press enter.
Move and resize the text box to where you want the text positioned inside the cell. (do this before replicating the section)
Format the shape and choose no fill and no border line.
To replicate, select all the cells with the data (A2 - C2 in this example), copy it and then paste below each other. The text box will replicate along with the selected cells that is being pasted.
Unfortunately you will have to change the username reference in each text box for every row since that information doesn't update dynamically, so it will involve additional upfront work to be done when setting up the template.

Brain fart:
Create two rows per entry, merge cells except the barcode celp, then have the barcode in the top cell and in the cell below have "Piet". Hide grid rows, will look the part.

Just throwing it out there.

 

[Sagax]

Brain fart:
Create two rows per entry, merge cells except the barcode celp, then have the barcode in the top cell and in the cell below have "Piet". Hide grid rows, will look the part.

Just throwing it out there.

I tried that first, the barcode font messes with the sizing of the cell so you can't get the name close to the barcode.

 

[RiaX]

Can anyone assist me with appointment date generating formula for Excel?

What I need to do is enter a date into a field then the next column must generate a date 4 weeks later or 28 days and the following column needs to show 8 weeks later or 56 days.

Thanks

 

[TribbleZA]

Take the current date and add 28? Then build in what you want to do if it falls on a weekend. The same for the last column - add 56 but account for the weekend days.

Unless the first date would never fall on a weekend - then just add the number of days you want to increase by

 

[Magnum]

Don’t look like a beginner.

Use the & sign instead of typing it out.

View attachment 1823699

Cold sweat running down my forehead hearing the "Ampersand" word again. Damn you C++

 

[RiaX]

Take the current date and add 28? Then build in what you want to do if it falls on a weekend. The same for the last column - add 56 but account for the weekend days.

Unless the first date would never fall on a weekend - then just add the number of days you want to increase by

Now when I do that for example =A1 + 28 the cell just goes #NAME!!! Or something like that.

I'm using 28 days and 56 days for 4 weeks and 8 weeks to avoid weekends. I'm trying to schedule chronic repeats

 

[Sagax]

Can anyone assist me with appointment date generating formula for Excel?

What I need to do is enter a date into a field then the next column must generate a date 4 weeks later or 28 days and the following column needs to show 8 weeks later or 56 days.

Thanks

Something like this?


The technical stuff:
Make sure that the "date" fields are formatted as dates and not general or numbers (I used a custom format dd-mmm-yy for the date shown here, but you can change it to whatever works for you)

To work out the dates I simply used =$A$3+(B2*7) and then replicated the formula to the right. All it does is add the total of the amount of weeks multiplied by 7 to the first date specified in cell A3. This way makes it easier if you want to add more weeks to the table or change the week count.

 

[RiaX]

Why the $ sign ? I used =A1 + 28 and it didn't work