Pull out the characters

Closed
atul - Jun 10, 2009 at 12:52 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jun 10, 2009 at 04:20 AM
Hello,

i have below character in a cell and i would like to pull out the characters where it starts from g- and end where the "," found , pls advise the excel formula.
CN=g-JP-Domain Users,OU=Japan,OU=xxxxx

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 10, 2009 at 04:20 AM
Hi
Use =MID(N13,FIND("g-",N13,1)+2,FIND(",",N13,1)-FIND("g-",N13,1)-2) change All N13 to your cell number where the text is present
0