ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Replacing ? (https://www.excelbanter.com/excel-worksheet-functions/127631-replacing.html)

ddate

Replacing ?
 
I have cells containing a question mark '?' that I wanted to replace with a
blank. When I did a replace for ? with blank it cleared out the entire cell.
Is the ? a wildcard of some kind?

Just can't figure this one out.

Teethless mama

Replacing ?
 
Edit Replace Find what:~? Repleace with: leave it blank Replace

"ddate" wrote:

I have cells containing a question mark '?' that I wanted to replace with a
blank. When I did a replace for ? with blank it cleared out the entire cell.
Is the ? a wildcard of some kind?

Just can't figure this one out.



All times are GMT +1. The time now is 06:56 PM.

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