remove asterisks?

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hi -

I have a range of general text cells that has an asterisk before the name ["
*johns " ]. I would normally use search and replace to get rid of unwanted
characters, but the asterisk is acting like a wildcard in the search dialog
box. any idea how to get rid of them?

thank you

Alan
 
Oops
~*

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


Ron de Bruin said:
Hi alan

Use it twice
**

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


Alan said:
Hi -

I have a range of general text cells that has an asterisk before the name ["
*johns " ]. I would normally use search and replace to get rid of unwanted
characters, but the asterisk is acting like a wildcard in the search dialog
box. any idea how to get rid of them?

thank you

Alan
Click to expand...
Click to expand...
 
I think you meant, use ~*.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Ron de Bruin said:
Hi alan

Use it twice
**

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


Hi -

I have a range of general text cells that has an asterisk before the name ["
*johns " ]. I would normally use search and replace to get rid of unwanted
characters, but the asterisk is acting like a wildcard in the search dialog
box. any idea how to get rid of them?

thank you

Alan
Click to expand...
Click to expand...
 
Yes

If you are looking for a tilde ~ you must use it twice.


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


Chip Pearson said:
I think you meant, use ~*.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Ron de Bruin said:
Hi alan

Use it twice
**

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


Hi -

I have a range of general text cells that has an asterisk before the name ["
*johns " ]. I would normally use search and replace to get rid of unwanted
characters, but the asterisk is acting like a wildcard in the search dialog
box. any idea how to get rid of them?

thank you

Alan
Click to expand...
Click to expand...
Click to expand...
 
Back
Top