Insert cell value into another cell within a text string

[dforce]

Hello everybody, I need to add a cell value (a date) into a text string like this example:

Delivery will be made on "Saturday 15 July 2024"

Saturday 15 July 2024 is a value of A5 cell.

I've followed several tutorial about this, it works with numbers but not with dates, but I can't understand where i am going wrong.

Thanks for helping.

I have Excel 2011 on Mac

d-force

 

[DanteAmor]

Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

If you literally have the data in A5: "Saturday 15 July 2024 is a value of A5 cell"

Note: July 15, 2024 is "Monday"

In other cell, try this formula:

="Delivery will be made on " & A5

_____ __
But if you have a date in cell A5, then try the following formula:

="Delivery will be made on " & TEXT(A5, "dddd dd mmmm yyyy")

----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

 

[dforce]

Hello DanteAmor, thank you so much, but I've tried this solution, but it still give me an error (see attachment).
This is what I don't understand...

 

[dforce]

If I add this formula

="Delivery will be made on " &A5

than I get this output

Delivery will be made on 45489

 

[Joe4]

If I add this formula

="Delivery will be made on " &A5

than I get this output

Delivery will be made on 45489

Yep, that means you need to use Dante's second formula:

="Delivery will be made on " & TEXT(A5, "dddd dd mmmm yyyy")

Note if your version of Excel uses semi-colons instead of commas as its formula argument separators (depends on your personal regional settings), then your formula will actually need to look like this:

="Delivery will be made on " & TEXT(A5; "dddd dd mmmm yyyy")

 

[dforce]

Hello Dante, if I use this formula

="Delivery will be made on " & TEXT(A5, "dddd dd mmmm yyyy")

Than I get the error that the formula is not correct
(see first attachment)

If I use the second formula

="Delivery will be made on " & TEXT(A5; "dddd dd mmmm yyyy")

Tham I get the error #NOME
(see second attachment)

 

[Joe4]

If you are using a Spanish version of Excel, you may need to change "Text" to "Texto", as shown here:

Excel Function Translations: English to Spanish // PerfectXL

List of Excel function translations from English to Spanish for if you’re familiar with the EN version but have to work with the ES version

www.perfectxl.com

So maybe:

="Delivery will be made on " & TEXTO(A5; "dddd dd mmmm yyyy")

 

[DanteAmor]

than I get this output

Delivery will be made on 45489

Sorry for the delay, I was on my lunch break.

If you have your functions in Italian, then use:

="Delivery will be made on " & TESTO(A5; "gggg gg mmmm aaaa")

 

[DanteAmor]

So maybe:
="Delivery will be made on " & TEXTO(A5; "dddd dd mmmm yyyy")

Hi Joe,
If the case were in Spanish, to obtain the year it must be: "aaaa"

="Delivery will be made on " & TEXTO(A5; "dddd dd mmmm aaaa")

 

[dforce]

Thank you Dante! You've made my day! It was because of the language (Italian)!
Thanks a lot!!!!