How to return data from text string in a cell

[merskamp]

I have Excel 2007.

In column A, i have several cells with long strings of data.
I need to clean up the cell and show only the data to the left of the second comma in each cell and to the right of the "=" sign which is always third from the left. The second comma doesnt always appear as the 7th or 9th or 19th character, else I could use a simple LEFT or RIGHT to solve.

Sample data. Each line is from A2:A6 on my spreadsheet.
In A2 I would return ... Account\, Test
In A3 ...Jones\, Sarah
etc...

Sample data:
CN=Account\, Test,OU=Test,DC=Slough,DC=tf-ty,DC=master
CN=Jones\, Sarah,CN=Users,DC=Slough,DC=tf-ty,DC=master
CN=Wayne\, Fred,OU=Test,DC=Slough,DC=tf-ty,DC=master
CN=Con Room 2\, Slough,OU=Res,OU=Slough,DC=Slough,DC=tf-ty,DC=master
CN=Thomas\, Jill.,OU=Offsite ,OU=Users,OU=Linden,DC=Slough,DC=tf-y,DC=master


Any help would be greatly appreciated.
Thanks,

 

[moonfish]

There is probably a faster way to do this but this works if sample data is in A1:
=RIGHT(LEFT(A1,FIND(",",A1,FIND(",",A1)+1)-1),LEN(LEFT(A1,FIND(",",A1,FIND(",",A1)+1)-1))-FIND("=",A1))

 

[merskamp]

Works a treat!!!!! Many thanks!