| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make it blank!
hi!
cell A1 has no data and seems tobe blank. but in B1 when I enter =ISBLANK(A1) it gives me FALSE!! what's wrong with me and how can I make the cell actual blank??? help me pl! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
make it blank!
You probably have a space or something in there. You can go EDIT - CLEAR or
press the DEL key. That should solve it. "via135 via OfficeKB.com" wrote: hi! cell A1 has no data and seems tobe blank. but in B1 when I enter =ISBLANK(A1) it gives me FALSE!! what's wrong with me and how can I make the cell actual blank??? help me pl! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
make it blank!
Did you have formulas that evaluated to ""?
Like =if(a17,"greater than 7","") And then did a copy|paste special|Values? If you did, you can clean up that range by doing this: Select the range to clean up edit|Replace what: (leave blank) with: $$$$$ replace all Then edit|replace what: $$$$$ with: (leave blank) replace all "via135 via OfficeKB.com" wrote: hi! cell A1 has no data and seems tobe blank. but in B1 when I enter =ISBLANK(A1) it gives me FALSE!! what's wrong with me and how can I make the cell actual blank??? help me pl! -via135 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
make it blank!
yes..Dave..u r absolutely correct!
thks for pinpointing the problem! -via135 Dave Peterson wrote: Did you have formulas that evaluated to ""? Like =if(a17,"greater than 7","") And then did a copy|paste special|Values? If you did, you can clean up that range by doing this: Select the range to clean up edit|Replace what: (leave blank) with: $$$$$ replace all Then edit|replace what: $$$$$ with: (leave blank) replace all hi! [quoted text clipped - 10 lines] Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make unused cells blank | Excel Discussion (Misc queries) | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Make a cell blank? | Excel Worksheet Functions | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
Linear Mode
