| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LastName, FirstName covert to FirstName LastName
I have a column with names, for example:
Last Name, First Name ie: Smith, Joe I'd like to be able convert it to: Joe Smith |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LastName, FirstName covert to FirstName LastName
Use dataText to columns
And after that use this in a new column =B1 & " " &A1 And copy down -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Craig860" wrote in message ... I have a column with names, for example: Last Name, First Name ie: Smith, Joe I'd like to be able convert it to: Joe Smith |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LastName, FirstName covert to FirstName LastName
Try this, where example Henry, John is in cell A1
=RIGHT(A1,FIND(",",A1)-2)&" "&LEFT(A1,FIND(",",A1)-1) This assumes the field always has the format LastName+comma+blank +FirstName |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LastName, FirstName covert to FirstName LastName
It worked for the first few names but as the length of names changed down the
list, it chopped part of the names. "HKaplan" wrote: Try this, where example Henry, John is in cell A1 =RIGHT(A1,FIND(",",A1)-2)&" "&LEFT(A1,FIND(",",A1)-1) This assumes the field always has the format LastName+comma+blank +FirstName |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LastName, FirstName covert to FirstName LastName
My mistake. This should fix it:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change lastname, firstname to firstname lastname in Excel? | Excel Discussion (Misc queries) | |||
| Firstname Lastname Field, Split two cells | Excel Worksheet Functions | |||
| FirstName, LastName and vice versa | Excel Worksheet Functions | |||
| Splitting firstName from Surname | Excel Worksheet Functions | |||
| Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) | |||
Linear Mode
