tag:blogger.com,1999:blog-2392561432908973850.post7776036304125306922..comments2023-03-24T16:58:50.565+05:30Comments on Microsoft Excel Tips: Filter Asterisk Character ("*")Prakash Singh Gusainhttp://www.blogger.com/profile/05142222674787092917noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-2392561432908973850.post-43922683051973881232021-12-14T20:03:10.202+05:302021-12-14T20:03:10.202+05:30Came across this during a search - very helpful th...Came across this during a search - very helpful thanks!Philhttps://www.blogger.com/profile/02303089862416785363noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-59181650274056470802018-09-12T16:34:26.815+05:302018-09-12T16:34:26.815+05:30Awesome article…..truly appreciated. We have an am...Awesome article…..truly appreciated. We have an amazing tool, You can try this out <a href="https://www.technocomsolutions.com/excel-search-replace-batch.html" rel="nofollow">Find and Replace in Excel</a> tool which help you to find and replace multiple words in multiples excel files . ThanksTechnocom Solutionshttps://www.blogger.com/profile/17788981764695706826noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-78716721277075288282016-02-12T15:59:59.117+05:302016-02-12T15:59:59.117+05:30that is awesome. thanks a lot for rare find tricks...that is awesome. thanks a lot for rare find tricks.Emrah ARSLANKEÇECİOĞLUhttps://www.blogger.com/profile/02643623772134399760noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-34100045021791405542015-08-27T19:12:45.058+05:302015-08-27T19:12:45.058+05:30Hi, It's help me lotHi, It's help me lot Nitin Sharmahttps://www.blogger.com/profile/06843542136703826367noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-26217455253277533682015-05-08T15:15:30.000+05:302015-05-08T15:15:30.000+05:30Or you can use ~* for each *
For one asterisk filt...Or you can use ~* for each *<br />For one asterisk filtering use ~*<br />For two asterisk filtering use ~*~*<br />Tilde is escape character. For each sequence of * you can use ~*Asadulla Javedhttps://www.blogger.com/profile/10092373958679104705noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-76383625084978540822013-07-12T22:35:12.605+05:302013-07-12T22:35:12.605+05:30very helpfulvery helpfulChris Camplejohnhttps://www.blogger.com/profile/13426394227739902229noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-13618932909659435162013-04-06T17:47:54.295+05:302013-04-06T17:47:54.295+05:30Tough ask Joko...
The above method won't wor...Tough ask Joko... <br /><br />The above method won't work in this situation. <br /><br />Suggesting work around... <br /><br />For all * in your data replace it with any sign (I am replacing it with $)<br /><br />Ctrl + H > In Find what field put (~*) and in Replace with field put ($) that will turn your data as follows <br /><br />$ hotel A<br />$ hotel B<br />$ hotel C<br />$$ alphabet Prakash Singh Gusainhttps://www.blogger.com/profile/05142222674787092917noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-59073288741708414362013-04-05T08:07:10.122+05:302013-04-05T08:07:10.122+05:30what if there's two asterisks. as in:
* hotel...what if there's two asterisks. as in:<br /><br />* hotel A<br />* hotel B<br />* hotel C<br />** alphabet hotels<br />* hotel 1<br />* hotel 2<br />* hotel 3<br />** numeric hotelsEncik Jay Xihttps://www.blogger.com/profile/02065761916171155353noreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-75917683714689741242013-02-27T07:35:47.850+05:302013-02-27T07:35:47.850+05:30Thank you, thank you, thank you!Thank you, thank you, thank you!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-76341491883353890332012-11-19T19:13:25.103+05:302012-11-19T19:13:25.103+05:30This helped me.This helped me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-9389333849325794482012-09-12T17:43:50.465+05:302012-09-12T17:43:50.465+05:30THANKYOUTHANKYOUAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-57725031551329410932012-08-08T13:53:00.430+05:302012-08-08T13:53:00.430+05:30thank you so much Mr. Prakashthank you so much Mr. PrakashAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-48369390873015153672012-04-27T02:22:35.119+05:302012-04-27T02:22:35.119+05:30Thanks for that tip...it really helps.Thanks for that tip...it really helps.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-3836361218664216632011-07-16T19:44:27.044+05:302011-07-16T19:44:27.044+05:30GOOD ONEGOOD ONEAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2392561432908973850.post-57395450114765716952011-02-22T01:11:00.528+05:302011-02-22T01:11:00.528+05:30very good trick.very good trick.Luckyhttps://www.blogger.com/profile/15163337119520878593noreply@blogger.com