Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cut and paste
I often get list that I need to cut and paste into cells from emails where a person's last name is first, what is the easiest way to switch the format to read their Name correctly starting with their first name? -- mvp ------------------------------------------------------------------------ mvp's Profile: http://www.excelforum.com/member.php...o&userid=34647 View this thread: http://www.excelforum.com/showthread...hreadid=544105 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cut and paste
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1) assuming first and family names are separated by a space. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=544105 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|