| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting firstname and secondname with functions
Does anyone have functions which will extract "firstname" and "secondname"
into seperate cells from a cell containing "firstname secondname" ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extracting firstname and secondname with functions
A1=John Brown
will be separated: to John: =LEFT(A1,FIND(" ",A1) and Brown: =RIGHT(A1,LEN(A1)-FIND(" ",A1)) HTH On 27 Mar, 18:38, "Mervyn Thomas" wrote: Does anyone have functions which will extract "firstname" and "secondname" into seperate cells from a cell containing "firstname secondname" ? |
|
#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" ? |
| 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) | |||
| Splitting firstName from Surname | Excel Worksheet Functions | |||
| Extracting data without using database functions | Excel Worksheet Functions | |||
![Mervyn Thomas[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
