Hi Mynda, My Excel for Office 365 didn't support the feature "get data from Microsoft Exchange. Therefore, I used PowerBI desktop instead. The prob...
Hi Danny, Yes, I also used the way you did. Thanks. Cheers, Julian
Hi Philip, Is it possible to type the string "MONTH" using DBCS and SBCS respectively in Excel? If this is the case then LOOKUP or MATCH function c...
Frans, I simply used the following formula to remove the first and the last characters of a DBCS string in cell A1 MID(A1,2,LEN(A1)-2) ...
Hi Sunny, Thanks again for your great support. I use date table quite often. Now that with your VBA script it's easy to add the holiday comments on...
Hi Sunny, Not beyond my expectation I would "meet" you again here. As you mentioned about I was looking for a solution to option 2, no need for the...
Hi Sunny, Yes, it solved my problem. Thank you again. Julian
Close the Excel file then open it again, It takes effective thereafter.
Hi Mynda & Catalin, Please accept my apoloy for not reply in good time due to my windows got a very bad problem unable to open it by all means ...