Are You Properly Using TEXT FORMULA in Excel ? Excel Formula Tutorial

Подписаться 1,2 млн

Просмотров 157 тыс.

50% 1

Are You Properly Using TEXT FORMULA in Excel ? Excel Formula Tutorial in Hindi 2021
Dosto is video me humne excel ke TEXT Formula ke bare me btaya hai ye chota sa formula hai but bahut kaam ka hai. excel me numbers or dates par hum easily number format lga saktey hain but agar text ke sath hume koi number ya date format change karke use karna ho to ye TEXT FUNCTION bahut kaam aata hai is video me Text formula detail me humne explain kar diya hai #excelfromulas #excelfunctions
in this video you will learn the best use of excel TEXT formula. How to use Text Formula in excel
My New Channel : bit.ly/3qFrbl5
Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
Vlookup Complete Tutorial : bit.ly/2K0C1Sb
Complete Microsoft Word Tutorial : • How To Do Office Work ...
Subscribe and Become Family Mamber of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / cse92
Thanks for watching #deepakeduworld

Опубликовано:

14 янв 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 125

@samirawati1975 3 года назад

Thanks Dr.deepak excel, mera kam ho gaya, main Jo question pucha tha uska javab mil gaya, thanks sir

@shyammauryatechfortechnica3580 2 года назад

Sir Jo aapne last mai date mai text ka formula use Kiya h sir mujhe ush mai kuch puchna tha sir jaise hame date 01-01-2022 ye date de rakhi h ab mai chahta hu ki aap text ka formula use kr k jaise kishi Khali cell mai 01 ye likhe tua Jo maine 01-01-2022 date di h issh k according 01 likhte he issh k upar aaj kon sa war h ye aa jaye sir isshe solve kro

@shankymhetre Год назад

I think reply nahi kar sakthe hai becz unkho bhi nahi atha becz most of ye jo lectures Lethe hai na unkhe suvidha khe anusaar Lethe hai but hum nee aisa koi questions pucha na Answer nahi dhethe becz unkho nahi atha hai simple

@pramodbhavsar4488 3 года назад

Very nice explain text formula in different example is very simply styles thank you sir

@amitkumaragrawal4158 2 года назад

apka sir jawab nahi, etna detail se ekdm bariki se samjhaya hai sir apne, ekdm crystal clear ho gya. sir ek req hai ek aisa formula pr video bataiye jo numeric value ko apne aap round off kre mtlb last me agar 5 se km ho to zero kr de or agar 5 se zayada to next digit ke kareeb round up kr de jaise agar 372 aye to 370 dikhaye or agar 377 aye to 380 kr de .i hope aap samjh gye hoge me kya chahta hu. pura youtube dekh liya kisi ni video ni bnaya hai or jihone banaya unka samjh ni aya. plz help me.

@Kingpotash 8 месяцев назад

Thank you dipak sir, your teaching style is very good

@malikafanhameed2740 3 года назад

Your way of teaching is good. Learned a lot

@Moizfoodi 3 года назад

Thanks sir jee... Your great God gifted as teacher.....thanks.. Shabir.Dubai

@InnerJyoti 2 года назад

Thank you so much sir ji for this video 🙏

@MrPZAHOOR 3 года назад

Love and respect you sir

@harshadhingu4783 3 года назад

Sir, Perfect.

@anjaneyulukodam9961 3 года назад

Thanks for your kind information. Good night sir,

@rajpanwar11 2 года назад

बहुत खूब

@AkhileshYadav-lt5sb Год назад

Good sir

@subechandyadav4094 3 года назад

Thanks for excel titorial

@nikhilkukde6704 3 года назад

👍👍 Great work sir Thanks.

@manojparashar4703 3 года назад

Good Work Deepak 👍🏻 Keep it up

@EGMStudio 2 года назад

Dear well-done I watch and follow your excel videos. I am facing one problem, I want auto generate product code, like I put my formula in A1 and my product will be show in B1 Column Like before I am doing (If B1="" ,"",A1+1) but now i want with text like "pro0001" and next pro0002"

@milindkulkarni3766 3 года назад

Very nice video Sir, Thank you Soo much

@CA_Maulik_Dhruv 3 года назад

Best used ... Thanks

@subechandyadav4094 3 года назад

Nice tutorial

@vimalsoni185 3 года назад

Sir jii aapki sabhi video itni achhi hoti hain Ki kbhi kbhi mein sochta hoon ki aapki taarif ke liye word kaha se laau 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

@DeepakEduWorld 3 года назад

😊😊😊😊😊♥️

@SheikhClaus 2 года назад

very good tutorial thanks for sharing

@rajsahu1029 3 года назад

Thanks

@sarfrazrabbani8827 3 года назад

How we will subtract the excess number from multiple required number and add remaining value in other cell in 1 formula. Eg we made 1 attendance sheet in excel using 8 hours per day, if in any cell showing more than 8 hrs would be consider overtime. So please explain me the formula if more than 8 hr showing (suppose it is showing 9, 11, 10, 10 in a month. I want to add excess number respectively 1, 3, 2, 2)

@prabhatverma4243 3 года назад

Bahut badiya

@uzairrazin3890 3 года назад

Thank you, Sir ji 🇧🇩

@akcomputers456 3 года назад

Nice work.. sir me ne ap k takreeban sari videos dekhee hai...kia ap school management system pr video bana sakty hai?

@shahzadsami5613 3 года назад

Great Thanks 👍👍👍👍👍👍👍👍

@muhammadtalha2078 3 года назад

Kindly upload vedio how to use text tab delimited function in excel 2016.

@pankajsaini50 3 года назад

Thank You 👌

@vikashmourya8964 3 года назад

Masterpiece

@parmeshwar44 2 года назад

Very nice sir

@deepakvaishy7754 3 года назад

Great Sir👌👌

@balajeekpyare7527 3 года назад

Thanks very much Sir ji

@vikashmourya8964 3 года назад

Badiya bhai

@dilipinamdarpatil6301 3 года назад

Nice one sir 👍

@GyanOnRandom 3 года назад

Fantastic 👍👍

@80upen 3 года назад

V.good explained

@comnetcns1 3 года назад

awsome sir...

@Parimal_Asodiya 2 года назад

👌👌👌👌

@ZeeshanAhmed-du6gq 3 года назад

Sir please excel file bhi share kardiya karen practice mai help ho jati hai 💐 from 🇵🇰

@rheapeter9709 Год назад

Thank you sir!!

@kalpananigam3943 Год назад

Mind-blowing 🇮🇳

@AlokKumar-ct7us 3 года назад

Thanks sir

@Kapilmuni_Tiwari 3 года назад

Nyc video sir

@geetuarora6931 7 месяцев назад

very useful video sir

@Nageshdewangan.4469 2 года назад

Great👍 teacher

@thesunil1971 3 года назад

Very nice You are great

@rajsahu1029 3 года назад

Very useful

@ZeeshanAhmed-du6gq 3 года назад

Well done

@xyzvideos288 3 года назад

Very good formula deepak

@khuranagee 3 года назад

I have subscribed your channel but never get notification for new video

@javedakhtar8724 2 года назад

Kya excel sheet m kisi ek alphabet se koi formula jo kisi line m likha usi line k formule ko me kisi dusri line me us tax ko click kr whi formula laga skta hu

@asiddareddy142 3 года назад

Sir power query usage with real time examples video share karo

@ShaheenAnsari-ii4qe Год назад

Nice sir ji 👌👌👌

@goyalmukeshkumar 3 года назад

Super trick

@kmanoj392 2 года назад

Nice sir

@MaiTran-xf3op Год назад

I have a format which I can use many times, how can I do if I don't want to replicate that format? I have written the text format in one cell and then refer text function to this cell (eg I have written """increase ""###,###;""decrease ""###,###" in cell A5 and then write formuala Text (A1,A5)) but it doesn't work.

@smartlearningwithrajeshrai 3 года назад

Excellent

@52ramiyer67 Год назад

good

@avtarmishra7549 2 года назад

Owsm

@radhefashion5669 Год назад

I want to write Profit declare is 12% of rs 1300000 12% bhi kisi column se select Krna hai And 1300000 sale ki value hai To kese set krenge sir... Please reply

@learnearn9388 2 года назад

Hi ...i have some doubts on excels as i need to develop excel applications for down loading data from the web and also so for analysing data ..can you support me on excel related queries. I have if i subscribe ...

@sandeepchavan455 3 года назад

Please make video on custom no format in detail

@parwejcomputereducation9459 3 года назад

Sir apki qualifications ky h Apne computer me koun sa course kiya h

@EmployeesCornerZia Год назад

How to bold or Underline text with & Sign (Due to joint text)

@neharajput4733 3 года назад

Training file for this video is not available in description. Plz provide sir.

@FoodieCravings13 3 года назад

Sheet last modified date kase dekhe formula se plz video baniye

@akulanarayana5284 3 года назад

Very very new on you tube excel

@pankajsaini50 3 года назад

👍

@MyAshukla 3 года назад

Excellant

@jasveer2sgnr 2 месяца назад

Font colour kaise change kre & formula ke sath, yani agar sirf "date" text ka color change karna ho aur cell reference ka bhi koi alag color Dena ho to kaise kare

@binaykumarnayak9114 3 года назад

Nice

@muhammadyounus2828 2 года назад

Hi sir ham excel me text per Kam karte hen ya formula per

@chetan1008 2 года назад

👍👍👍

@nikhilkukde6704 3 года назад

👍👍

@AftabAhmed-uw4ki 2 года назад

Sir mujhe Data entry ki course kr na RU-vid pe koi achi link send kro

@abdainawi 3 года назад

Like the way. Brother says aaxle me na

@subechandyadav4094 3 года назад

Sir ms word basic to advance video upload kare

@skstudy3053 3 года назад

Nice Sir ji

@MuhammadTanveer-9797 Год назад

How to colum A1, 01 Bottle and 02 Bottle Come written yah condition formatting and format cell In excel please help me

@mdtahseenfaizi2751 2 года назад

Advance excel ka notes hai to send me please sir

@jattjeetsingh2533 3 года назад

Hie sir mujhe ek hii column mai 2 serch criteria chaiye jese A2 mai ram likha hua h or A3 shyam hai then mujhe A4 mai kya likha hua hai ye search krna h

@Mukesh_gangwar7268 Год назад

Hello sir agar excel me ek hi cell me text>mukesh>text likha h to mukesh ko alag cell me kaise kare .

@hippargisudhir 3 года назад

Flash fill is easy method sir

@rinkuvohara7688 3 года назад

दीपक जी कही पर सम माइनस में आता है तो स्पेल नंबर का फार्मूला कम करना बंद हो जाता है कृपया गाइड करे

@ranjanhldr123 3 года назад

How can a number like 1234987650 can be written in text spelling in excel using simple formula

@ramashishchaudhary8716 3 года назад

How to check out remarks value from 2 sheet

@driving_131_ 3 года назад

Sir vo automatic attendance sheet muje bhejiye na sir please

@rajsahu1029 3 года назад

One simple problem. When we split data (text to column) like 5/3,Nirala nagar,9/6,Lucknow. I am getting that 5/3,9/6 are changes to date like 5 March, 9 Jun. Please give solution on text to column formula

@DeepakEduWorld 3 года назад

I ll include this query in next excel tips video 🙂🤗👍

@IDonTKnow-ip5ig 2 года назад

when im text formula in which month.. like 01-02-21 formula is =text(input cell,"mmm") but one problem every time show month name jan when cell is empty plz help me

@shahwali106 2 года назад

Sir how to convert the digits to in words

@RajaSharma-co7or 3 года назад

Thank you ❤️

@naveensharma-cg2tn 3 года назад

I want to concetenate decimal number with text upto 2 decimal point in excel . How can I

@DeepakEduWorld 3 года назад

"#.00"

@pknewknowledge6629 3 года назад

Sir text ka kya use hai

@nikhilkukde6704 3 года назад

Sir office 2019 me F2 Se cell edit nahi ho raha hai iske liye kya kar sakte hai ?

@vimalsoni185 3 года назад

Aap excel options ke advanced option me jaakar allow editing directly in cell wale option ko check krke ok kijiye Or phir try kijiye ho jaayega 👍👍👍

@nikhilkukde6704 3 года назад

@@vimalsoni185 ok thank you so much.👍👍👍👍👍👍🙏🙏🙏🙏

@DataLearninghub 3 года назад

@@vimalsoni185 👌👌

@pknewknowledge6629 3 года назад

Sir ye new version mein kaam karta hai kya

@DeepakEduWorld 3 года назад

Available in All versions

@ranjitkumarsahoo1794 3 года назад

Why do we use & before use formula

@debasmitapothal1642 3 года назад

Where is training file?

@mohamedadjal8502 3 года назад

hi, Professor , I have a question: If we have numbers in different formats, for example: liters, meters ... When we do research (we use search functions) in the cells that contain these numbers, can we get numbers with their different formats? Thank you so much.😃👍

@mohamedadjal8502 3 года назад

Good morning, when we use the search functions in Excel, we do not get the cell formatting that we are looking for. I want to get the full cell format. Is that possible? I thank you for all the efforts you are making through these videos, thank you so much.😃👍

@mohamedadjal8502 3 года назад

Good evening Professor, I thank you for the answers that you sent me on the Internet. May God protect you. Suppose we have in cell a1 = "excel", in cell a2 = "is", in cell a3 = "fun", in cell b1 = 12.00m, in cell b2 = 10.00gr, in cell b3 = 15.00kg, use the vlookup function: vlookup = ("is", $ a $ 1: $ b $ 3,2, false), the result is 10, which means that This function didn't give me the full format of the number in cell b2 (b2 = 10.00gr), but my goal is to get b2 = 10.00gr and not b2 = 10. thank you so much.😃👍