| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell order
I have two spread sheets with names of the same people on
them with different info on each. The master workbook has the names in a cell as a FIRST LAST format. I want to bring data in from another workwork which has the names listed as LAST, FIRST. is there a marco which will go through a column and switch the order? thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell order
Chris,
This should work Sub NameSwitch() For Each Cell In Selection a = InStr(1, Cell.Text, ",") Last = Mid(Cell.Value, 1, a - 1) First = Mid(Cell.Value, a + 2) Cell.Value = First & " " & Last Next End Sub Dan E "Chris" wrote in message ... I have two spread sheets with names of the same people on them with different info on each. The master workbook has the names in a cell as a FIRST LAST format. I want to bring data in from another workwork which has the names listed as LAST, FIRST. is there a marco which will go through a column and switch the order? thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell order
I should have mentioned, back up before you try it, because their is no Undo!
"Chris" wrote in message ... I have two spread sheets with names of the same people on them with different info on each. The master workbook has the names in a cell as a FIRST LAST format. I want to bring data in from another workwork which has the names listed as LAST, FIRST. is there a marco which will go through a column and switch the order? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change series plotting order without changing legend order? | Charts and Charting in Excel | |||
| For chart syles, why doesn't color order match series order? | Charts and Charting in Excel | |||
| how to set a tab order in Excel 2003 for PC? (go cell to cell) | Excel Discussion (Misc queries) | |||
| How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Linear Mode
