Forum Discussion
Roselle1
Aug 10, 2020Copper Contributor
basic help: how to sort a mail merge address list
Hi we are working on sending out letters and have a mailmerge list of names and addresses. every piece of data is int a separate column on the same row. how do we sort the list alphabetically by la...
Tracey76
Aug 10, 2020Copper Contributor
highlight the cells with data
Data Menu
Sort
if you have headers tick the box and the drop downs will show the information from the top row, if not then don't tick and you just tell it which column to sort by
If you want to do Surname and then 1st name then you can add a level, top one surname, 2nd row should be 1st name
Data Menu
Sort
if you have headers tick the box and the drop downs will show the information from the top row, if not then don't tick and you just tell it which column to sort by
If you want to do Surname and then 1st name then you can add a level, top one surname, 2nd row should be 1st name