| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| TEXT CELLS OVER 40 CHARACTERS | Excel Discussion (Misc queries) | |||
| Changing an excel spreadsheet into a text delimited file | Excel Worksheet Functions | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
| create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Linear Mode
