{"id":12120,"date":"2012-01-19T10:39:53","date_gmt":"2012-01-19T10:39:53","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1265"},"modified":"2022-08-06T20:21:22","modified_gmt":"2022-08-06T20:21:22","slug":"udf-to-extract-numbers-special-chars-alphabets","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/01\/udf-to-extract-numbers-special-chars-alphabets\/","title":{"rendered":"Excel UDF: To exctract All Numbers, Special Characters and Alphabets from a String"},"content":{"rendered":"
Sometimes you require to Extract All Numbers and Characters from a mixed String. I have written a UDF (User Defined Function) to extract them.<\/p>\n
Add the below Code in any of your Regular modules of the Excel VBA Editor. Now go to your Excel Workbook and Type this formula. It will extract All the Special Characters, Numbers, and Alphabets separately as shown below: <\/p>\n
<\/p>\n