Hello,
how can i replace blank cell into specific word-
Current output -
| F1 | F2 |
| 435345 | 675756 |
| 56757 | 1232143 |
Expected Output
| F1 | F2 |
| Debit | Credit |
| 435345 | 675756 |
| 56757 | 1232143 |
Thank you
Kauser
Solved! Go to Solution.
IF [F1]=Null() OR IsEmpty([F1]) THEN "Debit" ELSE [F1] ENDIF
Then repeat again for F2!
