NULLs and empty strings

Hi All,

In Excel 2007, how can I search all cells in all worksheets in a spreadsheet for an empty string, and replace each occurence with a NULL?

I want to do this in Excel - not programatically.

Really hope someone can help.

Thanks,

T.

You can use the build in "Find and Replace" function.

1) Press Ctrl+H
2) Expand the options (press the options button)
3) Change the "within" from Sheet to "Workbook"
4) Set the Find to be whatever you want to find
5) and the replace to whatever you want the find to become

That should do it.

...but what do I enter in Find for empty string?
And what do I enter in Replace for NULL?

Don't put anything in the find field.

I'm a bit confused what you mean by "NULL"? The string "NULL" or nothing. Wouldn't an empty string and null be the same thing then? Or do you mean an empty string as in " " (a space) and you want to remove the spaces.

Perhaps you can post a sample of data so we can get an idea.

I definately mean NULL as in nothing, not string "NULL" - i.e. I want ISBLANK() on the cell to return TRUE. Currently I have cells which appear empty, but for which ISBLANK() returns FALSE. If I then hit delete on that cell, ISBLANK() will return TRUE. But I want to clean the whole spreadsheet similarly in as few steps as possible. Any ideas..??