| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine data in two columns into one and sort the combined column alphabetically..how??
I have two columns, A and B. Each column contains a list of data in
text format e.g. 01TI518A.PV . It is possible that duplicates of this text may appear within either column. Also, the number of data values in each column is variable as they are imported from an external source into the worksheet. I would like to be able to combine the text from both columns into a single list in a single column, say column C. I would also like this column to be alphanumerically sorted. How do I go about doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine data in two columns into one and sort the combined column alphabetically..how?? | Excel Discussion (Misc queries) | |||
| Can I combine 4 columns of data into one column? | Excel Discussion (Misc queries) | |||
| how do you sort ascend two columns alphabetically | New Users to Excel | |||
| How do I sort a column alphabetically not consider "the" or "a"? | Excel Discussion (Misc queries) | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
![Tommy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
