| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using Excel, how do I replace cells containing blanks with nulls?
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? |
|
#2
|
|||
|
|||
|
Select the range, press F5, special and Blanks, press enter, now type
whatever you want and press ctrl + enter Regards, Peo Sjoblom "Nither1" wrote: 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? |
|
#3
|
|||
|
|||
|
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. On Mon, 9 May 2005 11:03:02 -0700, "Nither1" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
| Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| How do I protect specific cells from changes in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
