Removing non text characters from spreadsheet
 

I am trying to remove a string of asterisks *** from a series of worksheets.
How do I indicate in the find box that I am looking for asterisks. I have
searched Help, and cannot find.

Removing non text characters from spreadsheet
 

Tilda can help yor.

Lokk for ~*
--
Gary's Student


"Katie59" wrote:

I am trying to remove a string of asterisks *** from a series of worksheets.
How do I indicate in the find box that I am looking for asterisks. I have
searched Help, and cannot find.

Removing non text characters from spreadsheet
 

hi!

CTRL+H

Find what: ~*
Replace with -leave blank-

click Replace All.

-via135



Katie59 Wrote:
I am trying to remove a string of asterisks *** from a series of
worksheets.
How do I indicate in the find box that I am looking for asterisks. I
have
searched Help, and cannot find.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=525757

Removing non text characters from spreadsheet
 

Thank you both, but in my case, I had already tried that and it does not
work. Maybe the other text in the cell makes a difference. In almost all
cases there are 3 asterisks and then text up tight. EX ***TSH(Thyroid
Stimulatin Hormone).
Oops! I was putting ~*** in the box, I just tried ~* and it worked. Thank
you!


"via135" wrote:


hi!

CTRL+H

Find what: ~*
Replace with -leave blank-

click Replace All.

-via135



Katie59 Wrote:
I am trying to remove a string of asterisks *** from a series of
worksheets.
How do I indicate in the find box that I am looking for asterisks. I
have
searched Help, and cannot find.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=525757