![]() ![]() ![]() For example, if your cells contain both first and last names, you will probably want to keep the space in between those names. However, there are times when you want to keep spaces between words. Hitting Replace All (keyboard shortcut: Alt+ A) will remove any instances of a space in the data set that you selected.Īlthough this method is really quick and easy, it's only useful for data where you want ALL spaces removed. Make sure there is nothing in the Replace with field. On the Replace tab, place one blank space in the Find what field. That will bring up the Find and Replace window. The keyboard shortcut for this is Ctrl + H. Then open the Find & Select dropdown menu. ![]() The first method for space hunting is to use the Find & Replace feature.Īfter highlighting the cells that you want to search through, go to the Home tab. That sounds like a sci-fi movie title, but it's just someone who can quickly locate and delete superfluous spaces in cell values.īased on my space hunting experience, here are five techniques I use frequently to clean up data. That's because they are not easy to spot, yet can cause frustrating calculation errors.Īfter many years of working with Excel, I've become a Space Hunter. Remove Blank Spaces AFTER.xlsm Space Huntingīlank spaces can be a headache for data analysts and formula writers. You can download the workbook that I use in the video, including the macro I wrote to remove blank spaces. Watch on YouTube & Subscribe to our Channel Download the Excel File ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |