| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dealing with Text in a Function cell
You're welcome!
Biff "Karen" wrote in message ... That did it! Thanks! "Biff" wrote: Hi! Try this: =IF('Reg Doc Tracking'!H2<"",'Reg Doc Tracking'!H2,"") Biff "Karen" wrote in message ... I have 2 spreadsheets in one workbook that contain some of the same data. I've used the following function to poplutate the data entered into one spreadsheet into the other with the same data: =IF('Reg Doc Tracking'!H2,'Reg Doc Tracking'!H2,"") It works fine with any dates that are entered but I run into a problem when I have text in the Reg Doc Tracking H2 cell. I need to be able to enter a date or text into the field and have it populate into the other spreadsheet that contains the same data. I'm working with Excel 2003. Thank, Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Capacity - text | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
| dealing with cell text limits | Excel Discussion (Misc queries) | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
Hybrid Mode
