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

Recent content by Belleke

  1. Belleke

    how to change formula

    It looks as the result that I want GrathH Thanks. :)
  2. Belleke

    how to change formula

    Example
  3. Belleke

    how to change formula

    =IF(E1="C purchased" to =IF(E11Like"C purchased" How to change?
  4. Belleke

    Embedding the Hyperlink( ) within a string of text

    Happy dreaming.
  5. Belleke

    Embedding the Hyperlink( ) within a string of text

    I don't understand the question anymore that's what happens when you click in the cell. Why, you can't have 2 ore more hypelinks in one cell. What do you want to accomplish
  6. Belleke

    Embedding the Hyperlink( ) within a string of text

    Something like this? Hyperlink in C10
  7. Belleke

    WORD doc Formula for Drop Down list without adding item one by one

    does this help? https://www.exceldemy.com/drop-down-list-in-word-from-excel/
  8. Belleke

    Need Help summarising excel data

    Glad to help. :)
  9. Belleke

    Need Help summarising excel data

    What about this?
  10. Belleke

    Combine this formula so that I get only result when cell is not Blank.

    Thanks p45cal, works perfect. @ vletm, sorry for the mistake, my bad.
  11. Belleke

    Combine this formula so that I get only result when cell is not Blank.

    =IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case")) Now I get Upper Case when cell is empty.
  12. Belleke

    Week-Off Days name

    Good luck with this set up. Suc6
  13. Belleke

    Week-Off Days name

    Something like this?
  14. Belleke

    how to get no. of counts which are less than 18:00hrs with specific condition in all dates

    There is no data at all. Wrong sample perhaps?
  15. Belleke

    How do I get rid of all TextBoxes in Excel via VBA (empty)

    Try Sub belle() Dim oTextBox As TextBox For Each oTextBox In ActiveSheet.TextBoxes If oTextBox.Characters.Count = 0 Then oTextBox.Delete Next oTextBox End Sub
See more
Back
Top