Extracting text from a string

**simonelvin** · 10-10-2014, 06:26 AM

Hi

im having difficulties in extracting a name from a text string. the string is as follows: CN=Adrian Mills,OU=ARP,OU=Misc,OU=EastSuffolk Users,DC=EastSuffolk,DC=local

What I want is the name, (i.e. Adrian Mills) from the string. The cell reference the text string is in is M12.

I have tried nu,erous efforts, but can only figure this out to return values up to the space, or comma etc.

Thanks!

**boopathiraja** · 10-10-2014, 06:34 AM

Try this

Formula:

=MID(M12,FIND("=",M12)+1,LEN(M12))

**Jockney** · 10-10-2014, 06:37 AM

Sorry Boopathiraja that would pull everything after the first "=" Simonelvin is asking for just the name within the string.

**boopathiraja** · 10-10-2014, 06:45 AM

Originally Posted by Jockney

Sorry Boopathiraja that wo.

Hi Refer post #5

**Jockney** · 10-10-2014, 06:34 AM

Formula:

=mid(m12,find("=",m12)+1,find(",",m12,find("=",m12)+1)-find("=",m12)-1)

**boopathiraja** · 10-10-2014, 06:37 AM

Ok then this

Formula:

=MID(M12,FIND("=",M12)+1,FIND(",",M12)-FIND("=",M12)-1)

**simonelvin** · 10-10-2014, 06:36 AM

Awesome, thanks guys!

**Jockney** · 10-10-2014, 06:49 AM

Sorry you posted that as I was letting you know. Good to see we both thought of the same answer. Nice to know I'm not doing everything the long way round

**boopathiraja** · 10-10-2014, 06:58 AM

thats fine

Extracting text from a string

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Re: Extracting text from a string

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extracting a text string from a URL, almost there

Extracting numbers and text from inconsistent text/number formatted string

[SOLVED] Extracting Text from a string of Text & Digits of variable length

Extracting text from a string

Extracting from a text string

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions