W webmax Member Jun 2, 2015 #1 Hi, I have the below data followed by Emp ID. From that i want to pick only the Employee ID after the Open bracket and before the close bracket through excel formula. Input Output Should come as Pavya B (A-5957) A-5957 Sikta Saha (T-4415) T-4415
Hi, I have the below data followed by Emp ID. From that i want to pick only the Employee ID after the Open bracket and before the close bracket through excel formula. Input Output Should come as Pavya B (A-5957) A-5957 Sikta Saha (T-4415) T-4415
Somendra Misra Excel Ninja Jun 2, 2015 #2 Hi, Please post a sample file. Your sample data is not visible . Regards,
