ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Delete asterisks from text in cells? (https://www.excelbanter.com/excel-worksheet-functions/12023-delete-asterisks-text-cells.html)

Glennlane1

Delete asterisks from text in cells?
 
"Find" finds every cell and "Replace" with null deletes everything in that
cell!

Jason Morin

Use ~* rather than *.

HTH
Jason
Atlanta, GA

-----Original Message-----
"Find" finds every cell and "Replace" with null deletes

everything in that
cell!
.



All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com