Pull out the characters

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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