| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a list from last name, first name to first name, last name
I have a list of names in Excel that looks like this Last name, First name (in one cell) and I would like to reverse it so that it is First name, Last name. Can anyone describe a procedure (possibly using Find/Replace) that will allow me to do that? Thanks. -- zgall1 ------------------------------------------------------------------------ zgall1's Profile: http://www.excelforum.com/member.php...o&userid=31652 View this thread: http://www.excelforum.com/showthread...hreadid=513402 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing a list from last name, first name to first name, last name
This is one way =REPLACE(A1&", "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=513402 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing a list from last name, first name to first name, last name
zgall1 Wrote: I have a list of names in Excel that looks like this Last name, First name (in one cell) and I would like to reverse it so that it is First name, Last name. Can anyone describe a procedure (possibly using Find/Replace) that will allow me to do that? Thanks. This is just out of curiosity ... nothing more, nothing less. Why should the result be "First name, Last name" (with the comma between the first name and the last name)? Convention in writing a full name (with the first name being written first) is that there is no comma between the first and last names. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=513402 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing a list from last name, first name to first name, last name
You are correct. That was my mistake. -- zgall1 ------------------------------------------------------------------------ zgall1's Profile: http://www.excelforum.com/member.php...o&userid=31652 View this thread: http://www.excelforum.com/showthread...hreadid=513402 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the name of a list. | Excel Discussion (Misc queries) | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
| Need to find oldest date in ever changing list. | Excel Worksheet Functions | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Linear Mode
