Search : in
By :

Pull out the characters

Last answer on Jun 10, 2009 9:20:56 am BST atul, on Jun 10, 2009 5:52:05 am BST 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « pull out the characters » in :
Characteristics of programming languages Show There are many programming languages, each corresponding to specific needs (formula calculus, character string processing, real-time, etc.) with each having specific characteristics and functionalities. Therefore, the choice of programming language...
Special characters Show Special character codings HTML standards require all code to be written in 7-bit ASCII, which means that accented characters are not allowed. Despite this, current browsers recognise accented characters; you can enter accented characters directly...
Laptop keyboard and Spanish characters Show Laptop keyboard and Spanish characters It is very difficult to obtain Spanish characters (punctuation and accents) on the laptop keyboard. On a conventional pc keyboard (105 keys), it is much easier than on a laptop. In...
X86 assembly occurrence of a character Showx86 assembly occurrence of a character Introduction Issue Solution Explanation Introduction The small assembly exercise below is for (Intel and AMD 32-bit) x86 architectures and uses the NASM syntax , an assembler, available...
[Oracle] Making use of special characters Show[Oracle] Making use of special characters Intro Solution Intro For some SQL queries, we need to search for strings containing special characters like '%'. Considering the below example, the need is to find records containing the...
[Linux]Deleting a file containing special characters Show[Linux]Deleting a file containing special characters If the file you want to delete a character starting with "minus" (-), the rm command consider the following as part of the command line. To remedy this, one solution is to precede the...
Download M.W.SMS Sender Show
Download Icy Tower Show
Download EASEUS Partition Master ShowEaseUs Partition manager Free, is software "par excellence". EaseUs Partition Manager easily and without error will resize your hard disk partition into any size you chose: Main characteristics of EaseUs Partition Free: Material support for...
Data transmission - Transmission modes ShowTransmission modes A given transmission on a communications channel between two machines can occur in several different ways. The transmission is characterised by: the direction of the exchanges the transmission mode: the number of bits sent...
Base64 encoding ShowBase64 encoding The concept of Base64 encoding entails using US-ASCII (non-accented) characters to encode any sort of data in 8-bit form. Email protocols were originally designed to send messages in plain text only. But as email systems vary...
Laptop Computer Show
Ask your question Reply

1

 Excelguru, on Jun 10, 2009 9:20:56 am BST

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 Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru
Ask your question Reply
They need your help