ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Replacing all ( * ) with ( - ) (https://www.excelbanter.com/excel-discussion-misc-queries/1155-help-replacing-all-%2A.html)

Jeam

Help Replacing all ( * ) with ( - )
 
When I try doing a find * and replace with - it replaces
everything in my spreadsheet (I believe it looks at the *
as a wildcard) Is there a way to just replace the fields
that literally have a * it in?

Thank you

Ron de Bruin

Hi Jeam

Use this

~*



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jeam" wrote in message ...
When I try doing a find * and replace with - it replaces
everything in my spreadsheet (I believe it looks at the *
as a wildcard) Is there a way to just replace the fields
that literally have a * it in?

Thank you




Frank Kabel

Hi
search for
~*

--
Regards
Frank Kabel
Frankfurt, Germany

"Jeam" schrieb im Newsbeitrag
...
When I try doing a find * and replace with - it replaces
everything in my spreadsheet (I believe it looks at the *
as a wildcard) Is there a way to just replace the fields
that literally have a * it in?

Thank you




All times are GMT +1. The time now is 06:41 AM.

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