Excel Text To Column Tips-1

We have the data like this. मेरे पास ऐसा डाटा है                       We need output like below. we have to split year, month & day. हमें नीचे की तरह आउटपुट चाहिए।                     Use of text column feature, we have to extract year, month & day. Text to Column feature का उपयोग कर , हमें वर्ष, महीना और दिन निकालना है । […]

Read more

Some Common Errors In Excel

Why error comes in excel during working ? काम करने के दौरान एक्सेल में Errors क्यों आती है?   For example, If we want to add numeric value, then both value should be numeric, for example =2+5, then output will be 7, but if add text value with number then excel will give error, =2+”Mouse”, then excel will give error.   उदाहरण के लिए, यदि हम numeric value को जोड़ना चाहते हैं, तो दोनों value numeric होना चाहिए, उदाहरण के […]

Read more

Work on worksheet tab in excel

  To go to first or last sheet First और last sheet पर जाने के लिए.               In excel 2010 or previous version we had the button to scroll to the first and last sheet. Excel 2010 या पिछले versions में हमारे पास first और last sheet पर जाने के लिए  scroll button था।   But from excel 2013 that buttons have been removed. लेकिन एक्सेल 2013 से उस बटन को हटा दिया गया […]

Read more

Indirect Function In Excel -1

We use Indirect function in excel to converts a plain piece of text which looks like a cell address into a usable cell reference. एक्सेल में  Indirect Function का प्रयोग कर हम Cell Address की तरह दिखने वाले Plain text को usable cell referent में convert करते हैं.   The address can be either on the same worksheet or on a different worksheet. Address उसी sheet पर हो सकता है या फिर दूसरे sheet पर.   Syntax INDIRECT(ref_text, [a1])   […]

Read more

Extract First Name From A Cell In Excel

                    I have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है.     Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name.   यहाँ हमें […]

Read more