Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel - MS OFFICE 2000
I have a spread sheet of client names and need to rearrange the order of them
from Lastname, Firstname to Firstname Lastname. Please help! |
#2
|
|||
|
|||
Excel - MS OFFICE 2000
If by "order" you mean the columns need to be transposed, you simply
need to "cut" the column containing the Firstname (click on the column letter and choose EditCut), highlight the column before Lastname, and choose InsertCut Cells. Hope that helps... |
#3
|
|||
|
|||
Excel - MS OFFICE 2000
The name information is all in one column in the format of :
Lastname, Firstname I need it to be in the format of: Firstname Lastname Hope this makes imy question more clear. "ajchula" wrote: If by "order" you mean the columns need to be transposed, you simply need to "cut" the column containing the Firstname (click on the column letter and choose EditCut), highlight the column before Lastname, and choose InsertCut Cells. Hope that helps... |
#4
|
|||
|
|||
Excel - MS OFFICE 2000
Ok, I see what you mean. Do the final results need to remain in one
column or can the names be broken apart into two columns? |
#5
|
|||
|
|||
Excel - MS OFFICE 2000
Using a helper column B, assuming your data in Col A starting A2, in cell B2
put =MID(A2,FIND(",",A2)+1,LEN(A2))&", "&LEFT(A2,FIND(",",A2)-1) and copy down. Copy and paste special as values to lose the formulas. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "workfordance" wrote in message ... I have a spread sheet of client names and need to rearrange the order of them from Lastname, Firstname to Firstname Lastname. Please help! |
#6
|
|||
|
|||
Excel - MS OFFICE 2000
Thanks so much! It worked!! Now I need to get rid of the Middle initials
for those entries that have them. Can you also assist with this? "Ken Wright" wrote: Using a helper column B, assuming your data in Col A starting A2, in cell B2 put =MID(A2,FIND(",",A2)+1,LEN(A2))&", "&LEFT(A2,FIND(",",A2)-1) and copy down. Copy and paste special as values to lose the formulas. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "workfordance" wrote in message ... I have a spread sheet of client names and need to rearrange the order of them from Lastname, Firstname to Firstname Lastname. Please help! |
#7
|
|||
|
|||
Excel - MS OFFICE 2000
No point reinventing the wheel - try here and let us know if you have any
problems:- http://cpearson.com/excel/FirstLast.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "workfordance" wrote in message ... Thanks so much! It worked!! Now I need to get rid of the Middle initials for those entries that have them. Can you also assist with this? "Ken Wright" wrote: Using a helper column B, assuming your data in Col A starting A2, in cell B2 put =MID(A2,FIND(",",A2)+1,LEN(A2))&", "&LEFT(A2,FIND(",",A2)-1) and copy down. Copy and paste special as values to lose the formulas. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "workfordance" wrote in message ... I have a spread sheet of client names and need to rearrange the order of them from Lastname, Firstname to Firstname Lastname. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |