Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine cells
Hi,
If what you mean is two columns with names and you want to get only one column with that two if the columns are A and B in C enter =A1&""&B1 The "" will do the space between both column if you need more space just left blank spaces between the "" Hope it help "exceler" wrote: I have 2 lists of names in the same worksheet. I want to alphabatise the two lists into 1 list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
Combine Cells | Excel Discussion (Misc queries) | |||
Combine Cells | Excel Discussion (Misc queries) | |||
Combine Cells | Excel Discussion (Misc queries) | |||
combine cells | Excel Discussion (Misc queries) |