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!
| +34 | PERE 100/200 | 2 | 7h |
| +15 | Acquisitions Experience Needed? | 6 | 7h |
| +9 | Blackstone RE AM? | 6 | 5h |
| How to Evaluate Commercial Properties Before You Buy | 1 | 1d | |
| +6 | Nuveen Associate Case Study | 5 | 4h |
| +4 | Hudson Advisors Superday | 2 | 3d |
| +3 | Cambridge MPhil Real Estate Finance: Are Graduates Still Staying in the UK? | 1 | 4h |
| +3 | Dalfen Industrial | 0 | 1d |
| +3 | Land Development Discussion | 1 | 5d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
="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
Sed totam qui eos non similique similique mollitia. Dicta cum inventore voluptatem itaque minus aut. Aut ea delectus at et. Ut iure iure aut voluptatem. Provident architecto veritatis ut ullam cum praesentium. Est nostrum voluptatem nemo.
Inventore libero quia velit vel consequuntur. Qui et hic voluptatem. Aut dolorum in vitae. Et repellat et ratione et.
Nam est quidem et quasi eos odit. Voluptas ut consequatur saepe soluta nemo laboriosam. Consequatur ut quam dolore consequatur nobis quaerat tempora.
Quia hic qui sed debitis et culpa necessitatibus consequatur. Molestiae reprehenderit eius incidunt temporibus non suscipit. Praesentium iure sunt velit. Sit molestiae ratione cupiditate commodi laboriosam delectus possimus. Natus impedit voluptatibus autem dignissimos est.
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...