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
@SRTechTips2 жыл бұрын
Like Comments Share And Subscribed For SR Tech Tips
@rehanshorts58472 жыл бұрын
Good knowledge sir 👏 👍 👌 🙏 🙌
@anilkambale60962 жыл бұрын
खूप छान व सोप्या पद्धतीने माहिती सांगितली आहे.
@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
Жыл бұрын
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
@imashafernando25072 жыл бұрын
I want to know how to to use "Left" Function with uppercase letters?
@SRTechTips
2 жыл бұрын
Same function (Uppercase, lowercase, Proper Case) No need any changes
@SRTechTips
2 жыл бұрын
Do you have to take out the word from the left and convert it to upper case?
Пікірлер: 8
Like Comments Share And Subscribed For SR Tech Tips
Good knowledge sir 👏 👍 👌 🙏 🙌
खूप छान व सोप्या पद्धतीने माहिती सांगितली आहे.
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
Жыл бұрын
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
I want to know how to to use "Left" Function with uppercase letters?
@SRTechTips
2 жыл бұрын
Same function (Uppercase, lowercase, Proper Case) No need any changes
@SRTechTips
2 жыл бұрын
Do you have to take out the word from the left and convert it to upper case?