Hi All Community Members,
I would like to share a strange problem with Microsoft Excel. We tried to initiate some Bill Payments to our Suppliers for which an Excel Sheet needs to be filed with Supplier bank details like Account Number, IFSC Code, Amounts etc which gets uploaded at Bank Site to...
I think the Excel File is marked as READ ONLY and so it is not allowing to change the core/base file and letting the user SAVE AS with a different name. Please check the file properties of the Excel File and change any read only option which should resolve your issue.
In Excel, you can create a User Defined Function to extract the first letters of every words in a cell. Please do as this:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.<...
I am Asha Kanta Sharma from India. I am currently working as Manager - Finance & Accounts and would like to gain and have a larger exposure in Excel and Data Analytics.
Hope to learn and share useful insight on this great platform for the benefit of all.