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
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

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"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,288
Messages
5,571,321
Members
412,382
Latest member
Langtn02
Top