text and cell values in 1 cell

RAMatgreenleaf

Board Regular
Joined
Sep 23, 2005
Messages
84
i can get it to show the value from 1 cell in the cell, but is it possible to pull the value from 2

i have a box saying what type of pavers are to be used
and a box showing how many sqare feet of pavers are to be installed

and i have
=J64& " sf of blue stone are to be installed"

this show the value of square feet of blue stone is to be installed

but where it says blue stone, i want it to grab a value of another cell, cell =G6 because that is a dropdown menue which lets me select which type of paver i want to use

so i want it to take the value of sqare feet and the type of brick

so it will say example of...
755 square feet of couventry3 are to be installed

where the 755 is value J64, and the coventry3 is value G6

thank you
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Just like you're using J64:

=$J$64&" sf of "&$G$6&" are to be installed"
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,056
Messages
5,835,158
Members
430,342
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top