Substring in Excel

Just to share a small Excel tip, inorder to obtain substring in Excel there is no direct way.
A small manipulation will do that trick.

1. Copy the Test Data to Column B2
2. And in the subsequent column paste the formula

This example will substring from char 'p' till it encounters first ','.

To get Substring in Excel - Formula

=MID(LEFT(B2,FIND(",",B2)-1),FIND("p",B2),255)

Test Data uniquemember=member1=psi00011111,o=staff,dc=1234,dc=com

Result - psi00011111