• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. ashakantasharma

    Microsoft Excel takes 8085002100000259 as 8085002100000250 which caused fund transfer to wrong Bank Account

    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...
  2. ashakantasharma

    excel hanging

    Get an i3, or i5, Switch to 64bit Office, Increase RAM, Close unnecessary applications.
  3. ashakantasharma

    Workbook Saving issue

    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.
  4. ashakantasharma

    Extract first letter from each word in cell

  5. ashakantasharma

    Extract first letter from each word in cell

    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.<...
  6. ashakantasharma

    Advanced Multi variable analysis and Graphs

  7. ashakantasharma

    Hide hyperlink worksheets

    Can you share a sample/demo Excel Files for reference ?
  8. ashakantasharma

    How to open shared folder which is in cloud through vba

    Open Excel and go open files option and add the network place in cloud where files are stored which can be opened.
  9. ashakantasharma

    FIND CELL (i.e-a1:c4) and or count cells of merge cells through formula

    You can also use =COUNTIF & =COUNTIFS if you want to count cells that match specific criteria.
  10. ashakantasharma

    Hello .. Introduce yourself

    Hello Everyone, 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.