Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
How can I extract First letter from first name, remove the space between first and last name and keep the last name? For eg: I have a list of Names in this format: John Doe Will Smith and I want them like this: jdoe wsmith Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract characters from Right of string | Excel Worksheet Functions | |||
How to extract specific text from a string of characters | Excel Worksheet Functions | |||
Extract all text without spaces and special characters | Excel Worksheet Functions | |||
Extract string w/ 7 characters | Excel Programming | |||
Extract string after specific characters | Excel Programming |