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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,215,140
Messages
6,123,269
Members
449,093
Latest member
Vincent Khandagale

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