Does anyone know if you can / how to reference a a number from cell A into a string of text in cell B? Example:
Cell A has: 7%
We want Cell B to reference that number in the middle of a sentence, ie: The cap rate used is 7% (Cell A).
So that any time the number in Cell A is changed it'll update in the full sentence in Cell B.
Let me know if that makes sense, thanks so much!
="The cap rate used is: "&text([Cell A],"0.0%")
This is the correct and most efficient way to go about it. Simple and as dynamic as necessary. Great way to create dynamic footnotes as well.
This is the best way to do it dynamically for a long text string and allows you to have multiple cell references and easily edit the text. If it's just a short string like "Exit cap of 7%" you can also just custom format the cell, but it's more annoying to edit the text if needed later (not significantly).
Do not use CONCAT function mentioned elsewhere. It's a less efficient, less clean version of simply using quotation marks and ampersands.
The =CONCAT function combined with the TEXT function will do this as well
Qui beatae porro saepe et architecto. Harum atque voluptatem asperiores sint iste. Voluptates maiores error pariatur accusamus architecto mollitia quod. Distinctio tenetur est ut mollitia dolorum dolore ut. At natus dolores culpa omnis et autem et.
Rerum blanditiis soluta ab ut facilis. Qui deserunt blanditiis ex id tempore. Eaque voluptatem deserunt atque est officia vel. Alias ex consequatur soluta odit et molestiae.
Voluptatem perspiciatis debitis minus rerum numquam ea debitis. Quod quibusdam ut natus cumque sed et repellendus. Doloribus ad enim modi dolor a sed. Commodi eum sit cum adipisci aspernatur maxime sed. Non quia velit sit doloribus voluptates maiores. Fugiat perferendis veritatis adipisci temporibus velit. Incidunt aspernatur eos sint autem saepe ut facere deserunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...