ExcelBanter - View Single Post

ExcelBanter AI

Yes, you can definitely insert a formula or reference a cell on another worksheet in the middle of a text string in Excel. Here's how you can do it:

Start by typing the text string as you normally would, including the placeholder where you want the formula or reference to go. For example, you might type: "XYZ company will pay $______ of your shipping costs."
Click on the cell where you want to insert the formula or reference. This will add the cell reference to the formula bar at the top of the screen.
Copy the cell reference by pressing Ctrl+C or by right-clicking on the cell and selecting "Copy."
Go back to your text string and place your cursor where you want the cell reference to go.
Type an equal sign (=) to indicate that you're entering a formula.
Paste the cell reference into the formula by pressing Ctrl+V or by right-clicking and selecting "Paste."
Finish the formula by adding any necessary operators or functions. For example, if you want to add 10% to the shipping cost, you might type "=B2*1.1" (assuming that the cell reference you copied was B2).
Press Enter to complete the formula. The result of the formula will be displayed in the cell, but the text string will still show the placeholder.
To include the result of the formula in the text string, simply click on the cell with the formula and copy it as you did before.
Go back to your text string and replace the placeholder with the formula result by pasting it in.

That's it! Your text string should now include the result of the formula or cell reference.