Auto pull 3 cells into 1 cell at different location? (Excel)

R

Roady

Hi:

If I have 3 cells (each in different column) and each with data, is it
possible to pull the data into one cell at a different location? In addition,
can you do this if one of the columns is a drop down selection? For example:

Column A- Star Wars
Column B- Luke
Column C- "I am your father"

On the cell it pulled to, it would look something like:

Star Wars; Luke; "I am your father"

thanks!
 
D

Dave Peterson

=a1&"; "&b1&"; "&c1


Hi:

If I have 3 cells (each in different column) and each with data, is it
possible to pull the data into one cell at a different location? In addition,
can you do this if one of the columns is a drop down selection? For example:

Column A- Star Wars
Column B- Luke
Column C- "I am your father"

On the cell it pulled to, it would look something like:

Star Wars; Luke; "I am your father"

thanks!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel partial cell compare to another cell 0
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Pulling one cell from Multiple sheets to one sheet 2
Excel 2 into 1 6
Multiple cells or columns are selected instead of selected cell or 1
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1
Mandatory cells only if another cell is filled 0
EXCEL: Separating data from 1 cell into multiple cells 5

Top