| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing Strings in Excel
Thanks! This is awesome :)
- Michael "Nick Hodge" wrote in message ... Or maybe you want them all lower case too =LOWER(REPLACE(MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1),FIND("@",MID(A1,FIND("(",A1),LEN(A1)-FIND("(",A1)-1)),9,"")) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Nick Hodge" wrote in message ... One possible answer in the other group, but if you want the names out as well then =REPLACE(MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1),FIND("@",MID(A1,FIND("(",A1),LEN(A1)-FIND("(",A1)-1)),9,"") (Assuming first email is in A1) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Michael" wrote in message ... I have a list in Excel from A1:A100 with names like the ones mentioned below: Michelle Fooo ) Myhaass Smith ) I want to parse them using string functions to the following format Any ideas how to do this using a formula? Thanks in advance Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
| Parsing Name Strings In Excel | Excel Discussion (Misc queries) | |||
| Macro to apply parsing rules for strings and list the substrings | Excel Worksheet Functions | |||
| String parsing with variable lenght strings | Excel Worksheet Functions | |||
| Parsing Text Strings | Excel Programming | |||
![Michael[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
