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

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!

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

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



Roady wrote:

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!

--

Dave Peterson