| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i convert names to initials in excel
I have a list of names in excel such as
Bill Smith Joe Bloggs Jock McTavish The entire name (forename and surname) is contained in one cell. The forename and surname are "space" delimited. How do I convert the forenames to initials so that the list will read B Smith J Bloggs J McTavish Thanks Dave Glynn |
|
#2
|
|||
|
|||
|
=LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(" ",A1)+1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "dave glynn" wrote in message ... I have a list of names in excel such as Bill Smith Joe Bloggs Jock McTavish The entire name (forename and surname) is contained in one cell. The forename and surname are "space" delimited. How do I convert the forenames to initials so that the list will read B Smith J Bloggs J McTavish Thanks Dave Glynn |
|
#3
|
|||
|
|||
|
Many thanks Niek
Dave "Niek Otten" wrote: =LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(" ",A1)+1) -- Kind regards, Niek Otten Microsoft MVP - Excel "dave glynn" wrote in message ... I have a list of names in excel such as Bill Smith Joe Bloggs Jock McTavish The entire name (forename and surname) is contained in one cell. The forename and surname are "space" delimited. How do I convert the forenames to initials so that the list will read B Smith J Bloggs J McTavish Thanks Dave Glynn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert excel file to executable file | Excel Discussion (Misc queries) | |||
| How to convert excel Docs to pocket excel on my mobile device | New Users to Excel | |||
| how i convert excel files with images to access | Excel Discussion (Misc queries) | |||
| how do i convert an excel file from a mac to a file on excel for . | Excel Discussion (Misc queries) | |||
| Still Convert Lotus 123 to Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
