Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last, First Name Swap
I've got two spreadsheets with names that I am trying to compare. Bot have full names stored in one field. One has normal FirstName Lastnam the other Lastname, Firstname. With about 2000 names to compare it's not going to be easy. Is ther anyway to swap the names so they are goth FirstName Lastname or vic versa? Thanks -- ~~ Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I swap cells | Excel Discussion (Misc queries) | |||
data swap | Excel Worksheet Functions | |||
swap | Excel Worksheet Functions | |||
I need to swap last name, first name in a cell to first name last | Excel Worksheet Functions | |||
swap axes | Charts and Charting in Excel |