Custom Data Validation in excel [ Hindi ] - Allow Text/Numbers Only || Set Character/ Digit Limit

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@sandeepulhe5044]

Sir,you are teaching very well. Thanks a lot sir.

[@legaldiary5401]

Bhai mein excel mein ZERO tha,but apke vedio dekh dekh kr accha excel operate kr leta hu...Uppr wala aapki umar lambi krein,aur hum jaise logo ko sikhate rhe,mere pass fee k paise nhi hote the computer sikhne k liye .jab main student tha,but ab aap jaise bhaiyo ki wajah se hi sikha h,jo kuch bhi aata h...thanks a lot...may God bless u

[@soumyajit3931]

Sir, can you please help me regarding a particular data validation topic, if the data is such that the first five characters will be alphabets only (A to Z) Sir, I can not use the istext function because istext function considers special characters also as text only. So how can I ensure that only alphabets are entered and not any thing else ? Sir, one more question, is there any function for special characters like isnumber or istext ? Thanking you

[@jyotikalra7393]

Thanks sir Aap hr option Bahut achhi tarah se clear krte hai

[@deepanshusharma3552]

Sir apki video very knowledge wali video hai or apne video me bhot easly explain kiya hai thanku sir

[@Musiclover-Rimpu]

namstey deepak sir ji aapke saare videos maine dekhe, sach mai mujhe excel nahi aata tha, lekin videos dekhne k baad mujhe excel aa gaya. thanks

[@kamalmaurya123]

Bhai tu bhot acche se smjhata h..thanks yaar...

[@DeepakEduWorld]

wlcm bro

[@pankajpatil606]

Aapka Explain Karne ka tarika bahut acha hai. Aapka ye video muje bahut acha laga. Thank You deepak bhai.

[@DeepakEduWorld]

+Pankaj Patil :)

[@narendersingh1020]

Deepak sir very very nice . You are a great teacher the method of teaching is very very good

[@kiran6602]

Thanx sir ap bhut achha explain krte hain....

[@biren09safety]

Deepak ji , Excellent your teaching method in KZbin Easily to understand . I am extremely glad for your tutorial

[@AnilKumar-go7hj]

Very nice video sir bahut jabarjast trick hai sir ji thanku sir

[@saswatibasu8802]

Aap bahut aache samjhte hai sir

[@RAMSINGH-sb6ou]

Aachi videoo kch nya shikhne ko mila thnx

[@dnyandeosomawanshi9271]

Very nice method of explaining & it ensures clarity. Thanks for good efforts towards spreading knowledge to all needy.

[@kumkumchakraborty2892]

your every video is very helpful thank you sir

[@shreyarai3794]

Very helpful video Deepak thanks...

[@mcreater1692]

love you sir... ❤🌻🥰

[@bijendraraghu6828]

Marbulous video sir Thanks for uploading video

[@narottammanihal8463]

Thank you Deepak Ji, Very useful

[@razamoulvi8801]

Thank you so much for your video..❤ aaeise hi video banate raho..🤗

[@DeepakEduWorld]

😊😊

[@supriyachoubey2985]

Thank you sir ,this is very usefull video 🙏🙏

[@MohdImran-vf3jt]

Bhut accha smghaya

[@rajakirasaoi7921]

thanks deepak it will help alot

[@veershettylakhe8011]

Veryhelpful sir thank you

[@monikabhardwaj6852]

Sir ur teaching style is very very good. Ur Every video is under stand able.very helpfull for me.

[@JackAJ]

Sir agar name ke saath koi digit enter karne se bhi true hi dikha raha hai... Wo kaise thik kare...?????

[@kanhucharanadas3948]

Jabardast Deepak sir..really very good

[@anilkumarsingh4560]

Very Useful Video Sir

[@jitendraray1521]

Excellent👍

[@milindkumarjawalgekar5641]

Thanks Deepak ji.

[@sankytech6474]

Bahut achcha laga.

[@pallaviagrawal7925]

V nyc explanation

[@Gujarati365]

Muje sir cell me 1g,3kg,3ton allow karna he par... Only 1,2,3 digit enter kare to error dikhani hey... To me kya karu.... Please inform me...

[@mdsani743]

Thank you very much

[@mahedihasan1882]

Your video very beautiful friend

[@Popular.Gossip]

Sir how do you work in zooming screen. During screen recording

[@nailashakeel4169]

sir the video is very useful . . i have learned so many things. i am a teacher. kindly tell me about which type of questions are asked in advance excel interview

[@gopasantra6925]

Very good video

[@aishajabeen9380]

great video sir thanku so much for this

[@arupsasmal4591]

Very useful, thanks

[@DeepakEduWorld]

kzbin.info/www/bejne/nKHWnauGpZiSedk watch it.. You may get an idea.. How to do it

[@shaukatsamad2510]

Deepak bhai the way of yr teaching is very unique n excellent lot of things n formulas have learnt from u , i drsire to know how v can put the specific numbers in a specific text that always indicate with that text ..... thank

[@DeepakEduWorld]

Custom number formatting 👍

[@debashisbhattacharyya5424]

Sir, How alphanumeric like PAN No. can be entered in a cell in this process?

[@AdarshMishra-yx4qk]

Many many thanks to u sir

[@manjit.sarania]

Very healthful sir

[@sajadbhat8834]

Excellent

[@pinkitiwari7423]

Thanks deepak sir

[@jamaludin-vb3fy]

An excellent video.

[@rajeshchhabria8136]

Great 👌

[@xlpointacademy5127]

Super Deepak

[@sandeeppareek6753]

Sir esme font pr bhi data validation lga sakte hai kya?

[@rakeshinfotech7296]

Sir ek error he Jab ham omprakash name type karte he to Jab ham o ke sthan pe zero (0) type kar dete he to bhi results true aata he

[@loveishawasthi8698]

Sir I want to know if data is in row position some data in below row but 1st 4 col blank & same in remaining row as it's and I want a data in another sheet except 1st row data wants & come out from 3rd row col no.6 ka data out come in another sheet lookup value in 1st row like 1st row and 1st col.

[@bijaykumar44]

Mast he bro...thnx and keep on...

[@DeepakEduWorld]

thanks

[@SANJAYSANYASI]

Sir excel me custom data validation by pan card number kaise enter karein

[@vijaypatil8523]

Sir ji yadi mujhe culum me vehicle no likhna he to koi formula he kya

[@amitverma7219]

Sir ek query hai ki text main sirf text aaye or kuch nahi example Amit likha aaya par agar Amit4 aaye to ye accept karta hai par nahi karna chaiye

[@ramkailashyadav1022]

thank you so much sir could you please add 1 videos how would be fix the capital letter in the cells of excel.

[@omkarkelshikar7484]

nice video sir

[@shahali7227]

THAN'S

[@nayeembasha3672]

Sir, You have excellent explaining skills. Your videos are very helpful for my day to day work in office. I have encountered a doubt. The validation cell/column is ignoring the validation when pasted other data. The cell should prevent and say that "the value you entered can not be allowed". Plz. clarify. Regards.

[@g.k.sharma6890]

Deepak ji ifsc code me 11 text+digit milakar hote he to hum kese 4 text aur 7 digit set kr skte he...Plz btaye

[@devendrarajput4563]

Sir man lijiye ki mob. No. Do types ke h, ek 7 digit ka or ek 10 digit ka toh aise condition me kaise is formula ko update krenge.. mtlb mob. No 7 digit ka accept kre ya fir 10 digit ka.. dono ke bich ka bhi digit accept na ho? I tried by using "OR" in the place of "AND" but it didn't work

[@krishsaha3043]

Sir lekin meye istext function use Kar raha hu aur cell meye "a123abc" lekh rakha hu Tb accept Kar raha hai ..tab Koi error msg show Nahi Kar raha.. Sirf only alphabet ke leye kya Karna hoga... Please help...

[@DeepakEduWorld]

A12fg4. Agar alphabet's ke sath kuch bhi mix hota hai.. koi bhi number ya symbol.. to wo text hi mana jata hai

[@alokmaheshwari3033]

Kya kisi work sheet ya kisi cell ya kisi row ya collom me esa kuch kiya ja sakta he ki usme kisi bhi case me likha jaye vo automatically propper ya upper ya lower case me convert ho jaye ??

[@DeepakEduWorld]

Ysss

[@alokmaheshwari3033]

Pls share

[@mohammadsubhan2955]

Sir please tell me permanently set word formula in excel all work book..

[@Musiclover-Rimpu]

sir mujhe ye bhi apko batana tha ki is video ke neeche jo custom data validation & number ki jagah numbes kiha hai.

[@pankirawat1444]

Nyc sir..👍 Aapki sari video superb h....👏 But mera bhi 1 *questions* h ki Sir jb text & numberic value 1 saath ho.. --> as232mf56df8 Agr aisa format ho to kya formula lagega ? Plz solve & Send video..🙏

[@cleanxcleanofficial9926]

Sir ma aik per different sheets sa data dropdown list bnana chahta hu kindly guide me

[@DeepakEduWorld]

kzbin.info/www/bejne/Y3qnopmtl95og68

[@vasantbhanushali2278]

Sir muje sheet me IFSC code lagana hai To kuch digit text me chahiye aur baki number me chahiye

[@DeepakEduWorld]

+Vasant Bhanushali ok... From home tab.. Go to number format.. Select cell range and choose text from number format option...

[@vasantbhanushali2278]

Deepak EduWorld Conditional formatting lagana hai Jaise ki ristrict data and no karna hai ek hi cell me

[@indranilbiswas1023]

very usefull

[@yopaji-d3z]

(?) hi bro , and len furmala is working only if we select one cell iit is not working on column of 12 cell, but if wee drag thatt one cell than it is working , can you please tell me how this and len formula working on multiple selection at one time . because i have tried this on 1 cell than its working , but when i gave it range of (a2:a12) than this formula is not working . please reply me.

[@acieducation6401]

Sir ji, Namste Sir ji meri ek word office 10 ki file hai jis pe password lga hai mai usk a password bhul gya hu uska password kaise remove hoga aur data bhi safe rakhana hai Please guide sir ji

[@DeepakEduWorld]

Its hacking dear.. If i publish such type of video. That will be illegal

[@acieducation6401]

@@DeepakEduWorld Sir ji usme bahut most data hai aur Jaruri hai

[@sankytech6474]

You can teach us ethical hacking, it's not illegal

[@vijayKUMAR-sk6yj]

pan card ka no. hai to kya formula lagayenge rply jaroor kriyega

[@anuj777pandey]

Sir agar 10 number lete hai or enter karte hai sahi chalta hai par data ko delete kar du to error deta hai ye kaise sahi hoga agar koi number dala 5-7 digit ka to error data hai Jo sahi par us data ko hata diya or phir enter kiya to error dene lagta hai massage dene lagta hai aisa kyo

[@fragrenceful]

sir mujhe yeh jan na hai ki if i enter same phone no or same aadhar no in cell to allow nahi kare. and vo bhi 10 digit ka to kaise setting and error alert may mesage likinge,please guide asap

[@rammilanyadav7149]

very good.

[@agra_foodtour6744]

Please share same process for google online sheet

[@SudipDas-fh7pj]

Ye formula Google sheet pe valid hoga?

[@maqbool1682]

Good job

[@hemantsingh6646]

Ky text or number ka validation dono ek sath use kr skta h example pan card number 10 digit ka hota h 6 text or 4 number to muje ek call ye validation lgna h ki mera text na to 6 se jada ya km or number 4 se jada ya km na ho

[@dipanshubisht8441]

sir agar ham s number 1 se 5 tk ak hi naam aye dusra naam a na ske sir pzl help me

[@ejazhussain156]

Dear Deepak, Main jab duplicate ka farmula lagata hon tou lagta naihy =countif( )=1Please Detail say bitainy.Ejaz hussain virk.

[@krmotionexcel]

Great tricks........on the line... Sir can you new file....... " Condition formatting & consolidate sheet ..........," Plz make it.............. 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@dipanshubisht8441]

sir agar ham s number se 5 tk ak hi naam likhana chahte hai to koi dusra naam na likha skhe pzl help me

[@maheshvyas8087]

Dynamic dropdown list without duplicates.Suggest your videos

[@wajidkhawaja4141]

Assalam o alikum sir thanks for you nice information plz btaye k number or alphabet ka aik sath validation rule kaise bnayae

[@DeepakEduWorld]

Plz video poora dekhiye dhyan se 👍

[@wajidkhawaja4141]

Nhi sir mean k hm aik aisa validation rule bnana chahey jis mai alphabets or numbers k ilawa or kuch agr hm apni file mai enter krna chahey tu wo excel hmey error dai dai

[@KuldeepSingh-hr3kl]

sir countif,len,ISNUMBER formula ek saath kaam kaise krte hai ,jaise phone no. 10 hi ho number me ho, dublicate bhi na ho

[@rakeshmishraish]

Please give me consolidate worked but name automatic not update in another sheet please help me

[@DeepakEduWorld]

Ok.. You have not linked data consolidation... While consolidating data... U will see a LINK DATA SOURCE option.. Just check this checkbox and click ok

[@perwezalam5444]

Sir ,welcom, deta entry ka kaam main jo heading hota hai usko requirment ke hisab se make karna parta ha ya apne se khud heading banana parta hai ek videos main deta entry ke headin ke bare main video banaye kya kya aur kaisa kaisa heading hota hai plzzz explain it Ok thanks sir

[@DeepakEduWorld]

🤗

[@vijaysharma-fs2nv]

Sir Agar yes or no ke liye data validation lagana hoto kya formula hoga?????

[@DeepakEduWorld]

Ok g u will publish video on this topic as soon as possible

[@fafasahat]

if you enter the cell no in starting with zero number this formulae is not work???

[@vasantbhanushali2278]

Sir please help because office me payroll IFSC code Kai Baar galat ho jata hai o ke badle 0 ho jata hai

[@KuldeepSingh-yj3zy]

Nice Bro

[@prabhakarpawar573]

Nice video

[@nazeefshah3583]

would you be able to share the custom validation to enter characters eg: 123L (Three number and one Alphabet)

[@akshayshishodia2749]

Sir isme 1 condition aur Ho ki number repeat Na Ho koi b mtlb no duplication wo kaise hoga

[@azazahmad4343]

Sir Android mobile me website block kaise hota hai jo Koi bhi browser Se Na Chale please sir Bataye Na

[@alokdada21]

How to calculate in cell 23+5 and sum all. Please give me link

[@shrineelvarnadadakikurpa8695]

Thank you

[@alamwarsi380]

power point par video banaiye

[@mukundpotdar9849]

I really really appreciate with your explanation and very much clarity. Thanks for you effort and knowledge sharing. But, I have a question, In case if user wan't to enter the character like CRC0002001, CRC0002002 etc. Its like your company code, employee code or anything similar. Can we do this using data validation or we have to use VBA.