If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
blank data field shows quote in formula, how to delete it?
In a data file I just received, many blank fields show a single-quotation
mark in the formula. The if statement does not recognize these fields as blank. I have tried to 'find and replace' the marks using a search for ' and also for ~' both without success. How can I fix these fields, in bulk, so they behave like blanks? |
#2
|
|||
|
|||
try
=if(or(a1="",a1=" "),1,2) -- Don Guillett SalesAid Software "wdanner" wrote in message ... In a data file I just received, many blank fields show a single-quotation mark in the formula. The if statement does not recognize these fields as blank. I have tried to 'find and replace' the marks using a search for ' and also for ~' both without success. How can I fix these fields, in bulk, so they behave like blanks? |
#3
|
|||
|
|||
Those cells may have contained empty strings ( "" ), that were copied,
and pasted as values. This leaves a remnant in the cell, that is displayed as a apostrophe, when you turn on ToolsOptions, Transition tab, Transition Navigation. To clear the cells, you can try the Edit/Replace technique that Dave Peterson describes he http://groups.google.ca/groups?&thre...B8F0%40msn.com wdanner wrote: In a data file I just received, many blank fields show a single-quotation mark in the formula. The if statement does not recognize these fields as blank. I have tried to 'find and replace' the marks using a search for ' and also for ~' both without success. How can I fix these fields, in bulk, so they behave like blanks? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Blank field until data is entered | Todd | Using Forms | 1 | July 29th, 2004 06:34 PM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |
Data for Chart with Blank Formula Cells | Frank Kabel | Charts and Charting | 1 | February 16th, 2004 08:42 PM |
Data for Chart with Blank Formula Cells | sparrowsm | Charts and Charting | 0 | February 12th, 2004 04:20 PM |