Share via

I have a text cell one the first sheet of a workbook (Time Card) that i want to show up on the last sheet (WK), I tried =if('Time Card'!E6"","",'Time Card'!E6) the formula shows up

Bill Tregunna 0 Reputation points
2025-12-04T16:05:32.51+00:00

its a memo field i need to show up on the other sheet.

Moved from: Microsoft 365 Insider | Excel | Windows

Microsoft 365 and Office | Excel | Other | Windows
0 comments
Answer accepted by question author
  1. Francisco Montilla 23,935 Reputation points Independent Advisor
    2025-12-04T21:28:40.85+00:00

    Hello,

    Enter this in the target cell on sheet WK exactly as shown, then press Enter:

    =IF('Time Card'!E6<>"",'Time Card'!E6,"")

    That pulls the memo from Time Card!E6 when it has content and leaves the WK cell truly blank when it does not. If the cell shows the formula text instead of a result, change that cell's Number format to General, press F2, press Enter, then retype the same formula.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.