‘Text’ refers to the cell you want to convert and is the number of characters you want to pull from the cell. To make this conversion, insert a column next to the zip code column and use the LEFT formula to extract the first five digits. 12345-6789, but you only need the first five digits. One example could be that zip codes have been entered with 9 digits, e.g. The LEFT/RIGHT/MID formulas allow you to select a cell from which you would only like certain parts of the content.
Just add a space in the top entry field and nothing in the bottom entry field and click ‘Replace all’, all extra spaces in your selected range will be deleted. You can also select a range of cells and only have the function replace the words in that range.īonus tip: The Replace function is also an easy way to delete extra spaces in cells. Notice you can select whether you want to replace entries only in the sheet you have selected or across the entire workbook. Simply type in the word you are looking to replace in the top entry field and the word you want to replace it with in the bottom entry field and click ‘Replace All’.
