If you want to replace the space with nothing, leave the box blank. In the Replace with box, type an underscore, dash, or other value.You can also click the Home tab in the Ribbon and select Replace in the Find & Select group. Press Ctrl + H to display the Find and Replace dialog box.Select the range of cells containing text strings that include spaces you want to replace.To replace spaces using Find and Replace: Recommended article: How to Delete Blank Rows in Excel (5 Fast Ways to Remove Empty Rows)ĭo you want to learn more about Excel? Check out our virtual classroom or in-person Excel courses > 1. In Excel, you can replace spaces in text strings with underscores, dashes or other values using Find and Replace, by creating a formula or by using Flash Fill. 3 Ways to Replace Spaces Between Characters in Excel Text Stringsīy Avantix Learning Team | Updated October 20, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019, 2021 and 365 (Windows)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |