Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Remove Internal Spaces in Excel String?
Microsoft Excel is a potent application that is frequently used for data analysis and manipulation. You might need to eliminate spaces from a string at some point while working with text data. These blank spaces are frequently present as undesirable characters that can skew your data or obstruct subsequent processing. This course will arm you with the skills to clean up your data and prepare it for analysis or presentation, whether you have a list of names or addresses or any other data that has to have spaces removed.
Therefore, this tutorial is made to accommodate users of all ability levels, whether they are Excel newbies or seasoned users wishing to improve their data manipulation abilities. Make sure you have a fundamental understanding of Microsoft Excel and its features before we start. Let's explore the world of Excel string manipulation and discover how to effectively eliminate internal spaces from your data if you're ready!
Remove Internal Spaces
Here we will first get any one of the values using the formula, then use the autofill handle to complete the task. So let us see a simple process to know how you can remove internal spaces in an Excel string.
Consider an Excel sheet where you have internal spaces in the cells, similar to the below image.
First, click on an empty cell and enter the formula as =SUBSTITUTE(A2," ","") and click enter to get the first value. Then drag down using the autofill handle.
Empty Cell > Formula > Enter.
This is how you can remove interspaces in Excel.
Note
The above formula will remove all the spaces in the cells.
If you want to remove all the spaces in Excel, use the formula =TRIM(A2).
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can remove internal spaces in an Excel string to highlight a particular set of data.
69 Views
