Hi,
I have data in which I need to extract some alphanumeric values. I have attached the sample workbook with the expected result.
Hi,
I have data in which I need to extract some alphanumeric values. I have attached the sample workbook with the expected result.
Try.Please Login or Register to view this content.
Best Regards,
Maras.
Try
Please Login or Register to view this content.
Simply
Please Login or Register to view this content.
Last edited by jindon; 05-18-2021 at 01:47 AM.
Code for UDF GetAlphanumeric
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 05-18-2021 at 01:05 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thanks all those who provided such a wonderful solution. All the code is working great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks