| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting firstname and secondname with functions
Hi,
You may also use Data Text to columns. Select space as the delimited (incluck the default Tab setting in the delimiter) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Mervyn Thomas" wrote in message ... Does anyone have functions which will extract "firstname" and "secondname" into seperate cells from a cell containing "firstname secondname" ? |
| 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) | |||
| Splitting firstName from Surname | Excel Worksheet Functions | |||
| Extracting data without using database functions | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
