Find and replace

[guest]

I am opening a .txt file and then use the delimit feature and delimit file by | then when i open the file the very first column i want to do find and replace, i am keeping find what field empty and then i am saying replace with "Unknown". it does'nt work.
do u know why?

[Mark W.]

What is it that you're trying to find?

[AJ]

If Excel can't find anything it won't do anything and you haven't specified anything for it to find.
If you're trying to replace the blank cells with "Unknown", then try copying this formula down another column
=IF(A1<>"",A1,"Unknown")

[guest]

I am trying to find "" but looks like there are no "". so how can i find what that cell contains when it shows blank and it is not "" so how to replace the contents of that cell with "Unknown"?

I tried AJ's formula but does not work it works on the cell in the rows where data on the work sheet ends after that it works

[guest]

Any one who knows answer to this?

[Mark W.]

On 2002-04-10 11:41, guest wrote:
Any one who knows answer to this?

Use an AutoFilter.

[guest]

Auto Filter only shows the values of 4 types which are there in data and shows blank and non blank

[Mark W.]

On 2002-04-10 11:56, guest wrote:
Auto Filter only shows the values of 4 types which are there in data and shows blank and non blank

Choose Custom and press [ OK ].

[guest]

It shows me those rows which i am trying to replace when i select blanks