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

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

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

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

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

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

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

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