| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing Strings in Excel
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
I put your two tests in Cells A1 and A2.
Paste this into a column and fill down: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) Cheers, Jason Lepack Michael wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
Jason
That won't remove the exchange bit (I suspect they've moved servers ;-)) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Jason Lepack" wrote in message s.com... I put your two tests in Cells A1 and A2. Paste this into a column and fill down: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) Cheers, Jason Lepack Michael wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
This was exactly what I was looking for.
Thanks Michael "Jason Lepack" wrote in message s.com... I put your two tests in Cells A1 and A2. Paste this into a column and fill down: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) Cheers, Jason Lepack Michael wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Parsing Strings in Excel
Michael
How does that remove the 'exchange' part? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Michael" wrote in message ... This was exactly what I was looking for. Thanks Michael "Jason Lepack" wrote in message s.com... I put your two tests in Cells A1 and A2. Paste this into a column and fill down: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) Cheers, Jason Lepack Michael wrote: 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 |
|
#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 |
| Reply |
| 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)
Linear Mode
