tag:blogger.com,1999:blog-7958828565254404797.post5267000884639635242..comments2024-03-28T07:44:59.527-07:00Comments on ListenData: Excel Formula for Extracting Text from Alphanumeric ValueDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7958828565254404797.post-54313969222240337642023-10-21T22:16:53.194-07:002023-10-21T22:16:53.194-07:00I have added the multiple ways to handle this issu...I have added the multiple ways to handle this issue. Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-14279212770599156712023-10-21T22:15:55.489-07:002023-10-21T22:15:55.489-07:00I have updated the formula. Thanks!I have updated the formula. Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-88731474257110188372021-06-30T18:28:35.668-07:002021-06-30T18:28:35.668-07:00THIS is what I need - but I need the numeric chara...THIS is what I need - but I need the numeric characters not alpha. Is there a formula?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-12596254775800386642021-04-27T02:18:42.759-07:002021-04-27T02:18:42.759-07:00Thanks a ton Deepanshu & Nitish WaliaThanks a ton Deepanshu & Nitish WaliaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-63548096846543094402020-12-22T02:45:52.003-08:002020-12-22T02:45:52.003-08:00Thanks a lotThanks a lotEducationhttps://www.blogger.com/profile/03927751645004670063noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-32839262998586523382020-11-24T17:35:38.784-08:002020-11-24T17:35:38.784-08:006+6=6+6=Anonymoushttps://www.blogger.com/profile/13581979657519505388noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-18490619509936578532018-10-31T06:11:51.464-07:002018-10-31T06:11:51.464-07:00Yo need to update the formula as it does not remov...Yo need to update the formula as it does not remove number zero from text <br /><br />=SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(+SUBSTITUTE(A2,"0",""),"1",""),"2",""), "3",""),"4",""),"5",""), "6",""),"7",""),"8",""),"9","")Nitish Waliahttps://www.blogger.com/profile/05852671430233586786noreply@blogger.com