Using Excel, how do I replace cells containing blanks with nulls?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I plan to use an Excel spreadsheetand cut and paste data into a database. I
need to replace blank cells in the spreadsheet with nulls. How can I
accomplish this?
 
Select the range, press F5, special and Blanks, press enter, now type
whatever you want and press ctrl + enter


Regards,

Peo Sjoblom
 
If I understand you correctly, Excel doesn't support the concept of the NULL
data type that you have in a database. To get that you may need to run a macro
from the database to replace, say, a "flag" value with a database NULL.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel putting random cells into date format 1
Deleting blank rows 4
find blank cell and replace with " ' " 2
Replace weird character 2
Find * and Replace 4
Replace Null value in Coloumn 2
How do I get Rid of the Circumflex Accent (Caret) 2
Cut & Paste in Excel without erasing cell borders? 1

Back
Top