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.
Firstly open excel sheet of your duplicate number 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. Pop-up open once you have to 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
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
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
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.
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 =RIGHT(A1,10) 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