![]() Suppose you have SSN data as shown below and you want to remove the dash and only get the numbers. Power Mac G5 Dual, lots of RAM, huge HDs and LightScribe drive, Mac OS X (10.5.8), TV OS 3.0.2 (160Gb). Is there a way to increase the size of the font in the formula bar above the spreadsheet Its tiny, and I cant see it without getting very very close to the screen. If you need to change the format of the cell to show at least 9 digits.Īlso read: How to Remove Question Marks from Text in Excel? Remove Dashes using FormulaĪnother simple method to get rid of dashes in Excel is to use formulas. Question: Q: formula bar text too small to see. This is something Excel does (try entering 001 in a cell and you will see it is changed to 1 only). ![]() When your number starts with a 0 (for example in 087-54-7465), this method would give you the result where the leading zero has been removed.In case you may need the original data later, make sure you create a backup copy before doing this. This is a really quick method to remove dashes in Excel, but there are a couple of things you need to know when using it: The above steps would remove all the dashes from the cells and you will be left with the numbers only. In the ‘Find what’ field, type the dash symbol (-). ![]() This will open the Find and Replace dialog box. Hold the Control key and then press the H key.Select the dataset from which you want to remove the dashes.Below are the steps to use find and replace to remove dashes in Excel:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |