Showing text and another cell

[spromislo]

This question feels so dumb and while I'm not great in Excel, I'm not terrible. But I don't know the answer. Is there a way to have constant text in a cell and then add text from another cell that is changing? I know how to do it with a formula first but I can't do it with only text. As an example I want Cell A1 to read "Deal A" and then whatever text is in Cell C1.

Thank you.

[Sam Capricci]

You can put this in A1 ="Deal A "&C1 (I left a space at the end of Deal A but you can remove that.

[63falcondude]

Hello and welcome to the forum.

Try this:
="Deal A "&C1

Edit: Beat to it!

[spromislo]

You guys are great. Another one, in two parts. If I have an number input in a cell (let's say 125) and I want it to be followed by text(let's say "months") I cant then use that cell in another formula right? I would love that cell A1 to say "'125' months" and then cell C1 to say 10 years and 5 months. I have been able to do it without the text of months in A1 and then having C1 read =ROUNDOWN(A1/12,0)&Years but I can't get the month portion of it worked out after that.

[63falcondude]

You can use a Custom format in cell A1 of # \m\o\n\t\h\s

Then type 125 into cell A1 and it will be displayed as "125 months".

You can then use this formula in C1:
=INT(A1/12)&" years "&ROUND(MOD(A1/12,1)*12,0)&" months"

Note that this formula rounds the number of months.

[Sam Capricci]

Dude, that's creative (# \m\o\n\t\h\s). never saw that before, nice!

[spromislo]

I'm simply amazed by this group. I'll try one more. If I need to calculate an expiration date in Cell B18....I have the start date in Cell B15 (8/1/19) and it runs through 13 months. Meaning the expiration is 9/30/20. If I do an EDATE using the start date and another cell with 13 months, it shows the expiration as 9/1/20. Is there a way to get it to move it to the end of the month?

[63falcondude]

Thanks Sambo! I appreciate the rep.

spromislo, try using the EOMONTH function.

That is:
=EOMONTH(B15,13)

[Flex-master]

Thanks! It's useful.

[63falcondude]

Happy to help!

To the OP, If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[majidsiddique]

Hi 63falcondude,
great technique boss, really fantastic.
Thanks.