| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lastname, first name
We had to assume something because you didn't tell us :)
"KIM W" wrote: I work a lot with names: We cannot assume the only space would be between last name and first name because there are many first names with spaces within them as well as last names with spaces in them. "Mike H" wrote: Hi, It depends on how the names are seperated. this assumes with a space First name =TRIM(LEFT(A1,FIND(" ",A1))) Last name =TRIM(MID(A1,FIND(" ",A1),LEN(A1))) Another way would be to select the column then data|Text to columns and follow the wizard. Mike "plubeski" wrote: I have a spreadsheet with 400 names listed lastname, firstname in once cell. Is there a function in Excel that would create two cells, one cell for lastname, and another cell for firstname? I'm not looking for the individual cell cut and paste option. Thanks, Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to separate FirstName and LastName ? | Excel Discussion (Misc queries) | |||
| LastName, FirstName covert to FirstName LastName | Excel Discussion (Misc queries) | |||
| How to change lastname, firstname to firstname lastname in Excel? | Excel Discussion (Misc queries) | |||
| FirstName, LastName and vice versa | Excel Worksheet Functions | |||
| Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) | |||
Hybrid Mode
