Leith,
Thanks again for the replay. I was able to troubleshoot what was the problem; I have a range linked with the Function, but this column is the concatenation of 5 columns, and I was inserting a space between the cell name and the concatenation character “&”, after removed the space everything work fine. Now that I found the root cause of that problem, I got another question;
How can I remove the space character (□) in this Function, when I link the data (all of this data are string word) the character appears in every empty cell or in a carriage return.
See attached
Thanks for you help!
Bookmarks