How Can I find and replace symbols in excel data ( white square)



  • 1. How can I make a row expand to fit the text I type in?
    When I type in text, the row seems to expand as I add more rows of type, but when I click off of it, only the first line of text is visible. I have checked "wrap text" but can still only see one line unless I manually drag to make the cell larger. Can someone please help???
  • 2. Can't open existing file
    Excel 2002 workbook - approx. 84K in size. Last saved 4/13/06. Click on file name to open today, 4/18/06. What I get is the Excel screen with some of the tool bar area greyed out, no workbook or even a worksheet showing, and most of the menu items greyed out. Any ideas what happened to this file?
  • 3. Find Permission option in Excell 2003.
    I am trying to secure an Excel workbook. I don't have the Permission option in File menu or on toolbar. How can I make it work?
  • 4. 3D Function Error
    Hi, I am trying to automatically update a summary worksheet. So basically anytime one of the other worksheets are updated, this summary is changed. Example, I have 7 tabs, each one representing software license purchases for a year, and then the seventh tab is a summary. Not all license titles are going to be the same on each tab, so I think I need to do an IF/SUM function of some sort. IF the text is the same, then add these cells from each worksheet. I followed the instructions to set up a 3D function but ran into a problem. Here's what I did. Opened spreadsheet and clicked on summary tab. Followed the instructions for a 3D function. Typed = in the refers to box. Clicked on the first tab and then held shift and clicked the last tab. It then says to select the cell or range of cells to be referenced. I selected all of the cells I wanted to reference on the summary tab. Is this wrong? Thanks, Steve P.

How Can I find and replace symbols in excel data ( white square)

Postby YWxhd2hpemtpZA » Thu, 16 Dec 2004 07:35:02 GMT

I need any input or help

Re: How Can I find and replace symbols in excel data ( white square)

Postby Frank Kabel » Thu, 16 Dec 2004 07:44:02 GMT

 http://www.**--****.com/ #trimall

Frank Kabel
Frankfurt, Germany

Similar Threads:

1.I need to replace a non printable character, A small white square

I have a discription for an item i'm uploading on to my website. But it won't 
upload the small white square or rectangle. I need to replace that item with 
a hard enter. Anyone have any suggestions?

2.How do I find and replace a symbol in an excel spreadsheet to find and replace a symbol in my worksheet

I need  help with finding and then replacing a symbol in my worksheet. In the 
find and replace box there is no way to insert a symbol there. I have tried 
to cut and paste as well as to insert the symbol in the find box. If anyone 
has an idea on how to replace a bullet with a comma please let me know. 

4.Find and Replace Technique to modify stock symbols.

I have a number of stock market symbols that I need to modify. For example, I 
must change: AAA.UN to AAA-UN. For some I need to modify AAA.UN to AAA-UN.TO 
. In short, I simply want to change a period to a dash and for some add 
period TO . Is there a way of developing a macro to do this or use the "Find 
and Replace"? I don't want to retype all the symbols - chance of errors and 
would take a very long time. 

Any help here would be much appreciated.
Thanks. Norm. to find replace text or symbol with carriage return

excel 2003
how to find text or symbol in each cell and replace with hard carriage return

6. How to find and replace all "*" symbols

7. find/replace * symbol

8. Find and Replace: Excel cannot find matching data?

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 43 guest