How To Use Right Left Mid Len Find formula In Excel

‪@SRTechTips‬
How to use right,left, mid,len,find function in excel
basic tips
advance tips
#right #left #mid #len #find

Пікірлер: 8

  • @SRTechTips
    @SRTechTips2 жыл бұрын

    Like Comments Share And Subscribed For SR Tech Tips

  • @rehanshorts5847
    @rehanshorts58472 жыл бұрын

    Good knowledge sir 👏 👍 👌 🙏 🙌

  • @anilkambale6096
    @anilkambale60962 жыл бұрын

    खूप छान व सोप्या पद्धतीने माहिती सांगितली आहे.

  • @abdullavazhayil4868
    @abdullavazhayil4868 Жыл бұрын

    I have 5 dashes "-"(instead of space) in a string..how will "find" 4th or fifth dash. Here it is described upto 2nd space ..

  • @SRTechTips

    @SRTechTips

    Жыл бұрын

    Example:- a,bc,bcdc,dshh,ehsggc,sdd Isame 5 "," available hai, 5 number ka "," ki position nikali hai Function 👇 copy and paste =FIND(",",G5,FIND(",",G5,FIND(",",G5,FIND(",",G5,FIND(",",G5,1)+1)+1)+1)+1) Isame G5 Within text hai matalab jaha pe hamara text hai

  • @imashafernando2507
    @imashafernando25072 жыл бұрын

    I want to know how to to use "Left" Function with uppercase letters?

  • @SRTechTips

    @SRTechTips

    2 жыл бұрын

    Same function (Uppercase, lowercase, Proper Case) No need any changes

  • @SRTechTips

    @SRTechTips

    2 жыл бұрын

    Do you have to take out the word from the left and convert it to upper case?