| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by location within a cell in Excel? | Excel Discussion (Misc queries) | |||
| Change location of auto saved back up copy of shared workbook? | Excel Discussion (Misc queries) | |||
| how to auto increment cell location within formula | Excel Worksheet Functions | |||
| how do I set up pull down menus within a cell; excel | Excel Discussion (Misc queries) | |||
| Creating Pull Down Lists in Excel cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
