Are You Properly Using TEXT FORMULA in Excel ? Excel Formula Tutorial
HTML-код
- Опубликовано: 19 авг 2024
- 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
Thank you dipak sir, your teaching style is very good
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.
Thanks
Thanks for excel titorial
Thanks Dr.deepak excel, mera kam ho gaya, main Jo question pucha tha uska javab mil gaya, thanks sir
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
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
Sir jii aapki sabhi video itni achhi hoti hain
Ki kbhi kbhi mein sochta hoon ki aapki taarif ke liye word kaha se laau
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
😊😊😊😊😊♥️
Nice tutorial
Thank you, Sir ji 🇧🇩
Very nice video Sir, Thank you Soo much
Thank you sir!!
Very nice sir
Your way of teaching is good. Learned a lot
Very good formula deepak
Thank you so much sir ji for this video 🙏
बहुत खूब
Thanks sir
V.good explained
Nice sir ji 👌👌👌
Super trick
Very nice explain text formula in different example is very simply styles thank you sir
👍👍
Great work sir
Thanks.
Thanks sir jee... Your great God gifted as teacher.....thanks.. Shabir.Dubai
I have subscribed your channel but never get notification for new video
good
Nyc video sir
Thanks for your kind information.
Good night sir,
Bahut badiya
Mind-blowing 🇮🇳
Nice sir
Thanks very much Sir ji
Owsm
Sir please excel file bhi share kardiya karen practice mai help ho jati hai 💐 from 🇵🇰
Sir power query usage with real time examples video share karo
Great
Thanks 👍👍👍👍👍👍👍👍
Great👍 teacher
Good sir
Good Work Deepak 👍🏻 Keep it up
Sir, Perfect.
👍
very useful video sir
very good tutorial thanks for sharing
Very nice
You are great
Sir ms word basic to advance video upload kare
Nice Sir ji
Best used ... Thanks
Badiya bhai
Love and respect you sir
Great Sir👌👌
How to bold or Underline text with & Sign (Due to joint text)
Please make video on custom no format in detail
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
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
Nice one sir 👍
Fantastic 👍👍
Very very new on you tube excel
Thank You 👌
Nice
Very useful
👍👍👍
Sheet last modified date kase dekhe formula se plz video baniye
👌👌👌👌
Excellent
awsome sir...
Like the way. Brother says aaxle me na
Well done
Nice work..
sir me ne ap k takreeban sari videos dekhee hai...kia ap school management system pr video bana sakty hai?
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
Flash fill is easy method sir
Excellant
👍👍
Kindly upload vedio how to use text tab delimited function in excel 2016.
How to colum A1, 01 Bottle and 02 Bottle Come written yah condition formatting and format cell In excel please help me
Masterpiece
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)
Advance excel ka notes hai to send me please sir
Hi sir ham excel me text per Kam karte hen ya formula per
Sir office 2019 me F2 Se cell edit nahi ho raha hai iske liye kya kar sakte hai ?
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 👍👍👍
@@vimalsoni185 ok thank you so much.👍👍👍👍👍👍🙏🙏🙏🙏
@@vimalsoni185 👌👌
Sir mujhe Data entry ki course kr na RUclips pe koi achi link send kro
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"
How to check out remarks value from 2 sheet
दीपक जी कही पर सम माइनस में आता है तो स्पेल नंबर का फार्मूला कम करना बंद हो जाता है कृपया गाइड करे
Hello sir agar excel me ek hi cell me text>mukesh>text likha h to mukesh ko alag cell me kaise kare .
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
How can a number like 1234987650 can be written in text spelling in excel using simple formula
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
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 ...
Sir apki qualifications ky h
Apne computer me koun sa course kiya h
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
I ll include this query in next excel tips video 🙂🤗👍
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.
Sir how to convert the digits to in words
I want to concetenate decimal number with text upto 2 decimal point in excel .
How can I
"#.00"
Use of hash?
Thank you ❤️
Sir ye new version mein kaam karta hai kya
Available in All versions
Training file for this video is not available in description. Plz provide sir.
1 ते 100 अंक तारीख के सात बदलना चाहिये (उदा.१/२/२०२१ तो 1 अंक और १/२/२०२१ या तो 2अंक आना चाहिए कोन सा फॉर्म ला यूज़ करे
Isi Text formula se hoga... Series se dates likho... Or text formula lagao.. format me "d" likho bas 👍
सर आप इस पे एक वीडियो तयार करे विनंती
@@aminpinjari4070
COLUMN H FORMULA RESULT
18 01-02-2021 =TEXT(H18,"d") 1
19 02-02-2021 =TEXT(H19,"d") 2
Sir vo automatic attendance sheet muje bhejiye na sir please
Why do we use & before use formula
Where is training file?
Sir aap kisi bhi comment ka jawab nahi dete hai
G btaiye 😊
ruclips.net/video/4koRe4rfRBg/видео.html