Category: Excel

Home / Category: Excel

How to Remove Duplicate Number in Excel Sheet

April 11, 2019 | Excel | No Comments

It is a very good tool through which we can remove to duplicate numbers too easy way is the only that will tool will remove duplicate numbers very easily and very easily remove let’s know how to remove all duplicates number.
First open excel sheet of your remove duplicate number in excel select the cells on which the duplicate number is in after selecting it, click on the Data menu, after clicking on the Data menu, click on remove duplicate

A pop-up will as you click on the remove duplicated That pop-up name will be remove duplicated. Press the OK button.

Menu >> Data >> Remove Duplicated >> Select Coums >> Ok Button

In just a few seconds, you can remove the duplicated numbers. excel is a very good tool in which a number can be handled very easily this possible by Microsoft excel

आप एक्सेल में डुप्लिकेटेड नंबर बहुत सरल रूप से निकल सकते हो बस आप के पास एक्सेल को भी वर्शन होना चाहिए फिर आप एक्सेल को ओपन करो आप उसके बाद आपको जो डाटा मेरे डुप्लिकेटेड नंबर को रिमूव करना है उस डाटा को पेस्ट करो फिर आप एक column में number रखो फिर उसके बाद आप मेनू की मददत से डाटा रिमूव करते हो

Menu >> Data >> Remove Duplicated >> Select Coums >> Ok Button

आप ऊप्पर दी वीडियो की हेल्प से देख सकते हो कैसे डुप्लिकेटेड नंबर को डिलीट किया जा सकता ये बहुत सरल है जो की एक्सेल की हेल्प से किया जा सकता है remove duplicate number in excel

2 Part: How to Remove +91 Number

How to Convert Text to Columns

April 11, 2019 | Excel | No Comments

There are lots of ways to remove space form excel. I’ll tell you three populist ways to remove space form excel
You want to place name and surname in different columns, then there is a way to excel too, first of all, we will know that the name and surname are different columns with any space
First, you open the excel sheet which gives space in the name an the surname as soon as the excel sheet is open where you have to paste name and surname please selected cells you have paste name and surname
After that go to the menu and select the data
After selecting menu data, then you select text to columns

Menu >> Data >> Text To Columns

Convert Text to Columns
Convert Text to Columns

After you have a pop up open which is called convert text to columns wizard
After you select the Delimited menu and click the next button
Then tick the space on right and press the next button and then click on the finish button

Click on Delimited >> Next >> Click on Space >> Next >> Finish

Convert Text to Columns
Convert Text to Columns
Convert Text to Columns
Convert Text to Columns

Then you can see that both the name and surname have come in different cells and the columns of both have been separated. in this way you can see that name and surname cells and columns are different.

Convert Text to Columns

How to Remove +91 in excel sheet

April 9, 2019 | Excel | 1 Comment

How to Remove +91 in excel sheet is a very common question for everyone. There are several ways in which excel can remove +91 India country code.
First of all, you need to add +91 mobile number to excel in cell A after that paste a command of excel into an adjacent column
After paste you select the command of that excel and scroll down your career as soon as you scroll down, you will see that +91 getting removable in the adjacent column and your mobile number will be removed.
In this column, the number of +91 out has been removed, select the cell number to remove +91 once you have selected, copy it, after copying, click on the right click right-click after clicking on the number three option special paste after the click special paste, you will open a pop on it by clicking on the value and pressing the OK button you can use Ctrl+N to add new page then Ctrl+V with help of a new page you will be able to see that your +91 number has been removed and the 10digit mobile is visible to you.

= RIGHT(A1,10)
This command can be used only for India’s number want to remove code for that country for the country’s code mobile number. Let me give you an example through how to use this command to remove the second country code.
Take for example
The mobile number in US country is in 9 digits and country code is +1
Believe that it is a US number +1 999999999. This command will be used to remove the excel =RIGHT(A1,9)
a command is displayed like this
= (its means equal)
RIGHT (its means directly by hand)
A1 (its means cell A column 1)
9 (it means the number in the mobile number)
in the example, you can understand
If you want to remove the country code form any excel sheet, you can remove the country code using the command. If you want to remove +91 number form India, then you have understood how to remove +91 and how t use the code different countries