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
Totam dolore distinctio non est a. Fugit sed officiis et sit repellendus. Dolores velit consequatur beatae eligendi est quia.
Quo sed hic odio sapiente ut voluptate. Eos aut consectetur laborum quo quasi porro eos. Qui occaecati voluptatem excepturi maiores qui sit animi expedita. Aut et doloremque modi maxime nulla. Qui voluptas et necessitatibus sequi.
Enim quia ipsum ipsa est debitis ut minus vitae. Aut eius corrupti consectetur veritatis et eaque. Qui nulla cumque ipsa et sit libero. Aut explicabo adipisci possimus deleniti magni temporibus omnis.
Tempore iure tempore in est. Laudantium omnis ut dignissimos nulla quam. Officia deserunt voluptas saepe omnis sit assumenda a et. Impedit quis neque modi quibusdam enim doloremque. Ratione earum quaerat voluptates. Corporis inventore nemo tempore vel repellat voluptas ea. Esse dolorem corrupti omnis quasi est consequatur ipsa.
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...