Remove Spaces between Characters and Numbers in Excel
Edited by Djinu, VisiHow, Eng
You're watching VisiHow. In this video, we're going to show how to delete all of the spaces from a column in Microsoft Excel. In this particular example, we have data obtained from Keyword Planner tool by Google. In each of these keywords, we want to delete all of the spaces to mimic a web site domain.
- 10You'll see that Excel has deleted all of the spaces within column "B".Now, close the "Replace" window.Advertisement
If you have any questions or comments on how to delete all of the spaces in Excel, please leave them in the space below. Thanks for watching VisiHow! Have a great day!
Video: Remove Spaces between Characters and Numbers in Excel
Referencing this Article
If you need to reference this article in your work, you can copy-paste the following depending on your required format:
APA (American Psychological Association)
Remove Spaces between Characters and Numbers in Excel. (2016). In VisiHow. Retrieved Apr 23, 2017, from http://visihow.com/Remove_Spaces_between_Characters_and_Numbers_in_Excel
MLA (Modern Language Association) "Remove Spaces between Characters and Numbers in Excel." VisiHow, visihow.com/Remove_Spaces_between_Characters_and_Numbers_in_Excel Accessed 23 Apr 2017.
Chicago / Turabian VisiHow.com. "Remove Spaces between Characters and Numbers in Excel." Accessed Apr 23, 2017. http://visihow.com/Remove_Spaces_between_Characters_and_Numbers_in_Excel.
Categories : Microsoft Suites
Recent edits by: VisiHow, Djinu