Functions/Formulas in Excel 5 - Combine Text and Formulas in a Cell

Learn how to combine text, cell references, functions, and formulas together all in one cell in Excel. This tutorial shows you how to make great use of text in conjunction with functions in Excel. You will learn to combine text and functions with the ampersand (&) character and when to use quotation marks. This is a great tutorial for those looking to improve their Excel skills.

Have a great day!

[AMMARvx]

after 12 years you still made someone’s day a lot easier, thank you!

[martinvfarago]

fckn Gem. Thanks man! You save me like 14 hours of work.

[parthmodi]

11 years ago but still so much helpful, thanks!

[Sam-nbrm]

Thought it was 13 years ago and would not work but it worked totally fine for me! Remember to add the blankspace as instructed in the video though!

[MrTitanfr]

thank you my good man...it was all I needed...this wraps up all the problems that I had

[arunrocketz]

Thanks a lot❤️. It saved my day😊..subscribed✌️

[Prathvi_Raj_Chauhan]

Great, finally I got this method.
Thanks

[himalayacarspa]

VEry Good explanation and simple to understand

[shoaibahmad]

you just helped me on speadsheet and macros sheet

[EreinaA]

You just helped me on my spreadsheet. Thanks!!

[johnpart]

Is there a way of formatting the totaled value, so that it now says Bob's Expenses were $476, 296? Thanks

[secle]

what will be the format of the cell, in this case ?

[khamsavengsengdala]

I can not custom the number, accounting, general

[serverlan]

It doesn't work for me, After putting in the text space and closed quotation mark and then a & I cant get the sum or any of the formal content to come up. It all just stays text. I tried formatting the column as currency but that didn't help...

[nick_aheh]

How do you do a sum of everything in column F?

[bagchand]

thanks for this information but i would like to know how to make a formula to write
(Provide dia of 8mm @ 150mm c/c)
whenever i change the diameter of bar which is i have given 8 and the spacing 150 to any other number in any other cell so that it automatically changes
it would be very helpful to me if u teach me how to do this
i will be waiting for ur reply

[rnamejonsal]

Date Failed Correction Due Date Overdue Clock
12/18/2018 1/1/2019 -105 Days
1/17/2019 1/31/2019 -75 Days
4/5/2019 4/19/2019 3 Days 3 Days or 4/19/2019
4/8/2019 4/22/2019 6 Days


how to create formula to combine the correction due date and overdue clock in one cell, to make it look like "3 Days or 4/19/2019"
please help, thanks in advance