• 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

    Hui...

  • 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. G

    how to sum digits within a cell..??

    Hi Luke, This formula is awesome..but request you to help me out in understanding the concept of the above formula.. I mean am unable to understand the concept of using {ROW(INDIRECT("1:"&LEN(B3))),} in the above formula.... Regards, Abhinav
  2. G

    how to sum digits within a cell..??

    Great ...thanks...
  3. G

    how to sum digits within a cell..??

    Hi, Am compiling some report received from different vendors wherein am facing little issue while adding some digits..as the vendor are sending some data in one cells for a individual person e.g. A B c Ram 24 Vicky 579 where i want the added total of B in C like 24 = 6, 579 = 21 as on...
  4. G

    Separate number from Text thru formula

    Hi Luke M, Thank you, The above formula is working perfectly...but as this is the mega formula am little confused to understand it. And am afraid if i have to make certain changes while using this formula whether it will work or not. Request you if u can illustrate the above both formulas...
  5. G

    Separate number from Text thru formula

    Hi All, Its been a very long time I had encounterd with a new problem. I used to get raw data from our different vendors who used to entry datas in Excel. Datas like Customer Name, Phone numbers, Address and many other stuffs as well. The problem what I am facing is they ( Vendor) used to...
  6. G

    How to work on dates before 1900 in Excel without using VBA codes!!!!

    @Montrey...i have to sometimes work on historical reports..may be thats enough for u..to understand...
  7. G

    How to work on dates before 1900 in Excel without using VBA codes!!!!

    Hi, My work is to make reports analysis..many more things...while I was working on a very little thing I encountered with the problem that for the dates before 1900 we need to use VBA codes.. Is there any options or alternatives to work on such things without using VBA codes.. Regards...
Back
Top