email import format issue

[Mileshigh]

can someone tell me how to fix this?

I exported my contacts out of outlook and need to modify them for importing them to gmail


this is the format outlook exported :

BOB, BUILDER - YAD (BBUILDER@HOME.COM)

All i want is whats inside the ( ) but each name and email varries in length but all have the same @home.com

Thanks
Brett

 

[t.powley]

Hi,

This formula is refering to the CELL A1 which contains the text:

BOB, BUILDER - YAD (BBUILDER@HOME.COM)


In CELL B1 enter the following formula:

=LEFT((RIGHT(A1,(SUM((LEN(A1))-(FIND("(",A1)))))),(SUM((SUM((LEN(A1))-(FIND("(",A1))))-1)))

This will give you the value of:
BBUILDER@HOME.COM

Copy the values and paste them into another column as values to make them usable.