| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting text from a cell in another tab
I'm trying to insert text from tab B cell A into tab A cell A, when I do this
and the cell is blank it shows a 0. What formula would I use to leave the cell blank if the text is empty? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting text from a cell in another tab
=IF(B1="","",B1)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Karen Smith" wrote in message ... I'm trying to insert text from tab B cell A into tab A cell A, when I do this and the cell is blank it shows a 0. What formula would I use to leave the cell blank if the text is empty? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting text from a cell in another tab
=IF(B!A1="","",B!A1)
Vaya con Dios, Chuck, CABGx3 "Karen Smith" wrote: I'm trying to insert text from tab B cell A into tab A cell A, when I do this and the cell is blank it shows a 0. What formula would I use to leave the cell blank if the text is empty? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting links/URLs into cell w/ other text | Excel Discussion (Misc queries) | |||
| inserting an additional line of text within same cell | Excel Worksheet Functions | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
