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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

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
Back
Top