| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get linked file from worksheet to = "blank"
Hi people of the superior power of excel, I have 2 worksheets Apple and Orange. Field A1 in Apple worksheet contains no information "blank" nothings entered. I want to copy the information in A1 Apple to A2 Orange. I assumed Field A2 Orange = Apple!A1. but the field shows the value 0. I changed the properties to text but it still shows 0. What is the correct formula to ensure field A2 Orange = "blank"? -- seno |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
Threaded Mode
