Dear everyone, please help me the difficulties in Excel that i can't find the solution last days.
I want to combine If and Substitue in excel to replace the content that i want in the message as :
" Thank you letter from Company Ltd. - Mr ABC - Director Company XXX ....... "
I want Mr ABC will be replaced by Mr DEF and if B6 is blank (without Company), the content will delete Director Company XXX ....
Bookmarks