| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting names in a list
I know there's a way to change names that are first name last name to a list
that is last name, first name. Can someone help me with this? Cheri |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting names in a list
It's not a Excel Formatting thing......and there are several ways to do it,
depending on EXACTLY how the names are arranged. One way is to highlight the column and do Data TextToColumns and use comma as the delimiter......this will break the names into two columns and then they can be CONCATENATED back together in the desired order..........things to watch out for with any automatic method is middle initials or names, prefixes, titles, etc. hth Vaya con Dios, Chuck, CABGx3 "Cheri" wrote: I know there's a way to change names that are first name last name to a list that is last name, first name. Can someone help me with this? Cheri |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting names in a list
Assume name in A1 with first & last separated by one or more blanks (no
middle name): in B1: =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(" ",A1)-1)) "CLR" wrote: It's not a Excel Formatting thing......and there are several ways to do it, depending on EXACTLY how the names are arranged. One way is to highlight the column and do Data TextToColumns and use comma as the delimiter......this will break the names into two columns and then they can be CONCATENATED back together in the desired order..........things to watch out for with any automatic method is middle initials or names, prefixes, titles, etc. hth Vaya con Dios, Chuck, CABGx3 "Cheri" wrote: I know there's a way to change names that are first name last name to a list that is last name, first name. Can someone help me with this? Cheri |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting names in a list
Slight mod to eliminate the comma following the last name.........
=TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) Vaya con Dios, Chuck, CABGx3 "Toppers" wrote: Assume name in A1 with first & last separated by one or more blanks (no middle name): in B1: =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(" ",A1)-1)) "CLR" wrote: It's not a Excel Formatting thing......and there are several ways to do it, depending on EXACTLY how the names are arranged. One way is to highlight the column and do Data TextToColumns and use comma as the delimiter......this will break the names into two columns and then they can be CONCATENATED back together in the desired order..........things to watch out for with any automatic method is middle initials or names, prefixes, titles, etc. hth Vaya con Dios, Chuck, CABGx3 "Cheri" wrote: I know there's a way to change names that are first name last name to a list that is last name, first name. Can someone help me with this? Cheri |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting names in a list
How would I get the comma between Lastname, Firstname?
"CLR" wrote: Slight mod to eliminate the comma following the last name......... =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) Vaya con Dios, Chuck, CABGx3 "Toppers" wrote: Assume name in A1 with first & last separated by one or more blanks (no middle name): in B1: =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(" ",A1)-1)) "CLR" wrote: It's not a Excel Formatting thing......and there are several ways to do it, depending on EXACTLY how the names are arranged. One way is to highlight the column and do Data TextToColumns and use comma as the delimiter......this will break the names into two columns and then they can be CONCATENATED back together in the desired order..........things to watch out for with any automatic method is middle initials or names, prefixes, titles, etc. hth Vaya con Dios, Chuck, CABGx3 "Cheri" wrote: I know there's a way to change names that are first name last name to a list that is last name, first name. Can someone help me with this? Cheri |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting names in a list
=TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & ", " & TRIM(LEFT(A1,FIND(",",A1)-1))
Cheri wrote: How would I get the comma between Lastname, Firstname? "CLR" wrote: Slight mod to eliminate the comma following the last name......... =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(",",A1)-1)) Vaya con Dios, Chuck, CABGx3 "Toppers" wrote: Assume name in A1 with first & last separated by one or more blanks (no middle name): in B1: =TRIM(RIGHT(A1,LEN(A1)-FIND(" ",A1)) ) & " " & TRIM(LEFT(A1,FIND(" ",A1)-1)) "CLR" wrote: It's not a Excel Formatting thing......and there are several ways to do it, depending on EXACTLY how the names are arranged. One way is to highlight the column and do Data TextToColumns and use comma as the delimiter......this will break the names into two columns and then they can be CONCATENATED back together in the desired order..........things to watch out for with any automatic method is middle initials or names, prefixes, titles, etc. hth Vaya con Dios, Chuck, CABGx3 "Cheri" wrote: I know there's a way to change names that are first name last name to a list that is last name, first name. Can someone help me with this? Cheri -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting how many different names in a long list | Excel Discussion (Misc queries) | |||
| How do I format list of names formatted last,first to first last? | Excel Worksheet Functions | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
| Setting up a random list from long list of names ? | Excel Discussion (Misc queries) | |||
Linear Mode
