I've learned how to create a formula that will insert a word/text into a cell
if its linked data is NOT NULL (from another worksheet)... but can I
differentiate between code/formulas and text in that cell?

In other words, the source cell has formula for a link from yet another
worksheet, so my worksheet cell reads that that cell is NOT NULL even though
there's no text in it.