You can use the raster calculator to assign a different value to the NoData cells:
Con(IsNull(InputRaster),9,InputRaster)
... but I am wondering, are you using a space to convert the text to columns? That should also solved the problem.
A question; what will you be doing with the raster in Excel? Maybe these things are also possible in ArcGIS...