About Us

Courie

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

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.

David Biddulph

="XYZ company will pay $"&Sheet6!A1&" of your shipping costs"
--
David Biddulph

"Courie" wrote in message
...
Is there a way to insert a formula or reference a cell on another
worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

MyVeryOwnSelf

Is there a way to insert a formula or reference a cell on another
worksheet in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of
your shipping costs... Where the blank was a reference from another
sheet.

One way is to use a formula like this:
="XYZ company will pay "&TEXT(Sheet2!A1,"$0.00")&" of your shipping costs"

The ampersand does concatenation of strings.

daddylonglegs

Another way is to use

="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

"Courie" wrote:

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

Courie

I have tried all of your suggestions--Thanks, by the way--but each of them
simply prints the verbiage of the function, not the result.

What could I be doing wrong?
--
Thanks,

Courie

"daddylonglegs" wrote:

Another way is to use

="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

"Courie" wrote:

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

Pete_UK

Maybe your cell containing the formula is formatted as Text. Use Format
| Cells | Number (tab) and choose General. Then double-click the cell
as if to edit it in order to activate the change in format.

Hope this helps.

Pete

Courie wrote:

I have tried all of your suggestions--Thanks, by the way--but each of them
simply prints the verbiage of the function, not the result.

What could I be doing wrong?
--
Thanks,

Courie

"daddylonglegs" wrote:

Another way is to use

="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

"Courie" wrote:

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

Courie

Thanks for your suggestion Pete, unfortunately, that didn't work either. The
cells were already set to General and I set them to Text, then re-set to
General and recalculated the sheet, but there was no change. The forumla
still prints and views as text.
--
Thanks,

Courie

"Pete_UK" wrote:

Maybe your cell containing the formula is formatted as Text. Use Format
| Cells | Number (tab) and choose General. Then double-click the cell
as if to edit it in order to activate the change in format.

Hope this helps.

Pete

Courie wrote:

I have tried all of your suggestions--Thanks, by the way--but each of them
simply prints the verbiage of the function, not the result.

What could I be doing wrong?
--
Thanks,

Courie

"daddylonglegs" wrote:

Another way is to use

="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

"Courie" wrote:

Is there a way to insert a formula or reference a cell on another worksheet
in the middle of a text string.

For example if I wanted to say: XYZ company will pay $___________ of your
shipping costs... Where the blank was a reference from another sheet.
--
Thanks,

Courie

Zac Brownell · 10:52 PM

Found this thread and also managed to find a solution to your problem, Courie. In my case, I was trying to generate some unique ID's for testing purposes. At any rate, I just wanted to push the ROW # of a cell into a String, copy/paste, and have it resolve itself. Here's how I managed to do it:

Code:

	Quote:
	
	
		
			
				
					Originally Posted by Courie
					
				
				Thanks for your suggestion Pete, unfortunately, that didn't work either. The 

cells were already set to General and I set them to Text, then re-set to 

General and recalculated the sheet, but there was no change. The forumla 

still prints and views as text.

-- 

Thanks, 



Courie





"Pete_UK" wrote:



 Maybe your cell containing the formula is formatted as Text. Use Format

 | Cells | Number (tab) and choose General. Then double-click the cell

 as if to edit it in order to activate the change in format.

 

 Hope this helps.

 

 Pete

 

 Courie wrote:

 

  I have tried all of your suggestions--Thanks, by the way--but each of them

  simply prints the verbiage of the function, not the result.

 

  What could I be doing wrong?

  --

  Thanks,

 

  Courie

 

 

  "daddylonglegs" wrote:

 

   Another way is to use

  

   ="XYZ company will pay "&DOLLAR(Sheet2!A1)&" of your shipping costs"

  

   "Courie" wrote:

  

    Is there a way to insert a formula or reference a cell on another worksheet

    in the middle of a text string.

   

    For example if I wanted to say: XYZ company will pay $___________ of your

    shipping costs... Where the blank was a reference from another sheet.

    -- 

    Thanks, 

    

    Courie

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find text in a string formula	Todd	Excel Worksheet Functions	5	June 2nd 06 04:12 AM
Return a formula as text string to a cell	Sharon	Excel Worksheet Functions	4	April 18th 06 05:40 PM
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM

Menu

About Us