| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change lastname, firstname to firstname lastname in Excel?
Can anybody help with this? Thanks!
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change lastname, firstname to firstname lastname in Excel?
=REPLACE(A1&" "&LEFT(A1,FIND(",",A1)-1),1,FIND(",",A1)+1,"")
-- Gary''s Student - gsnu200764 "mert" wrote: Can anybody help with this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Firstname Lastname Field, Split two cells | Excel Worksheet Functions | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| 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
