Hello all,
I am looking to Paste "Value" from a workbook that I am the author of to a workbook that I am not the author of and cannot edit format or formulas. The Value I want to paste is generated from an "IF" formula. When the resulting value is " ", is actually a NULL string. When pasting contents of the cell and pasting as a value, it will show blank but there is data in the cell. This data is used to "CONCATENATE" in conjunction with the "ISBLANK" function, text in another cell. The "ISBLANK" function is recognizing the NULL string as not being blank. I have provided an example with formulas to mimic my problem. In the attachment I have laid out my questions and scenarios. Thank you all.
Forumexample.xlsx
Bookmarks