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
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 ..
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?
Same function (Uppercase, lowercase, Proper Case) No need any changes
Do you have to take out the word from the left and convert it to upper case?