VBA to Loop Through Each Character in a String - Excel VBA Text Mining String Functions

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ต.ค. 2024

ความคิดเห็น • 19

  • @wasifabbas8160
    @wasifabbas8160 2 ปีที่แล้ว +3

    Great stuff

  • @kumarcamukesh
    @kumarcamukesh 4 ปีที่แล้ว +2

    good one bro in very plain and simple language .

  • @lingesh3539
    @lingesh3539 4 ปีที่แล้ว +3

    Excellent bro

  • @ExcelMadeEasy444
    @ExcelMadeEasy444 4 ปีที่แล้ว +2

    Superb explains.

  • @JATINKUMAR-qu4vi
    @JATINKUMAR-qu4vi 2 ปีที่แล้ว +2

    Awesome 👍😊

  • @sahebraophalke6986
    @sahebraophalke6986 ปีที่แล้ว

    Hello sir Namaskar,
    Very useful n easy to understand video u r uploading.
    I m using A2 to D2, some it could be A2 to G2 or up to K2 for different work. Every time i need to define range A2 to G2 or as mentioned. Sir how can i set dynamic for column range from A2 to G2 or D2 to J2 or any column range, pl make video on it. Thanks......Mr Phalke

  • @Mannabhav
    @Mannabhav 4 ปีที่แล้ว +2

    Nice

  • @RoshanKumar-mp4wg
    @RoshanKumar-mp4wg 3 ปีที่แล้ว +2

    Hi, Could you please help me with how to split the number and alphabets for eg: if in A1 cell the value placed is ABCD1234 then how we can split it by using loop to loop through each character to splitting of text and numbers into separate column

    • @prasadvirus
      @prasadvirus 3 ปีที่แล้ว +1

      use divisive algorith to segregate
      for eg: you can only divide a number and not alphabet so you get error everytime you try to divide an alphabet, use that as a condition to segregate....bol

  • @willemmulder7304
    @willemmulder7304 4 ปีที่แล้ว +2

    Very nice!!
    I am in need for a piece of code that counts the number of dollar signs or " in a formula. How can I do that?

    • @ExcelDestination
      @ExcelDestination  4 ปีที่แล้ว +1

      you can add one if condition to evaluate each character and compare that with dollar sign.

    • @willemmulder7304
      @willemmulder7304 4 ปีที่แล้ว +1

      @@ExcelDestination Thank you! I will try

  • @AdityaKumar-fi5dl
    @AdityaKumar-fi5dl 3 ปีที่แล้ว +2

    Hi, am in need of some help with a VBA, is there a way to contact you as I found all your videos useful... Thanks in advance

    • @ExcelDestination
      @ExcelDestination  3 ปีที่แล้ว

      for any excel vba project, you can write to exceldestination@gmail.com