<div>
do the followings<br />
<br />
with holding the control keyboard select columns E, G and J &nbsp;then<br />
<br />
in the home tab then on the editing &nbsp;Find and Replace option select &nbsp;&quot;Go to Special&quot; in the dialbox select &quot;blanks&quot; then click Ok<br />
then put a space or whatever you want to replace the blanks cells with. then hold Control key and press enter in the keyboard.<br />
<br />
all of the balank cells will replace with the signed value.
</div>


do the followings

with holding the control keyboard select columns E, G and J  then

in the home tab then on the editing  Find and Replace option select  "Go to Special" in the dialbox select "blanks" then click Ok
then put a space or whatever you want to replace the blanks cells with. then hold Control key and press enter in the keyboard.

all of the balank cells will replace with the signed value.

<div>
What if I want to replace NULL values with blank values in the cells?
</div>


What if I want to replace NULL values with blank values in the cells?

<div>
<div class="content wysiwyg-content">
How would you assign a blank value to empty cells so that they are not interpreted as NULL values when saving an Excel 2010 file as a tab delimited text file? <br />
<br />
For example, values in columns E, G and J should not have any Null values.<br />
<br />
I will ultimately be importing this tab delimited text file into a Sybase table using DBArtisan's import wizard and some fields in the Sybase table have &quot;Nulls = No&quot; setting.
</div>
</div>


How would you assign a blank value to empty cells so that they are not interpreted as NULL values when saving an Excel 2010 file as a tab delimited text file? 

For example, values in columns E, G and J should not have any Null values.

I will ultimately be importing this tab delimited text file into a Sybase table using DBArtisan's import wizard and some fields in the Sybase table have "Nulls = No" setting.

How would you assign a blank value to empty cells so that they are NOT interpreted as NULL values when saving an Excel file into a tab deliminted text file?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.