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
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
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
Related:
- Pull out the characters
- Characters in dinosaur game - Guide
- Facebook special characters - Guide
- Kt naruto mod apk unlock all characters - Download - Adult games
- How to fix keyboard keys typing wrong characters - Guide
- Resident evil village characters - Guide
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
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
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
