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 Salutations From Names Cells in Excel?
Names frequently begin with salutations like "Mr.," "Mrs.," or "Ms.," but these and other salutations might occasionally cause errors in your data or obstruct specific activities you want to carry out. Excel offers effective tools to execute this operation with simplicity, regardless of whether you have a sizable dataset or only a few names and salutations. This step-by-step tutorial will show you how to organise your name cells, get rid of any salutations, and end up with names that are clear and salutation-free. By the end of this session, you'll be equipped with the knowledge and abilities required to successfully manage your data and guarantee consistency throughout all of your Excel spreadsheets.
Make sure you have a fundamental understanding of Excel's functions and formulae before we start. All users, from novice Excel users to experts, can benefit from this course. So let's get started by eliminating those annoying salutations from your name data and making it clean and consistent!
Remove Salutations From Names Cells
Here we will first use the formula to get any one of the values, then use the autofill handle to complete the task. So let us see a simple process to know how you can remove salutations from name cells in Excel.
Step 1
Consider an Excel sheet where you have a list of full names with salutations similar to the below image.
First, click on an empty cell and enter the formula as =RIGHT(A2,LEN(A2)-FIND(" ",A2)) and click enter to get the first value.
Empty Cell > Formula > Enter.
Step 2
Then drag down using the autofill handle. Then you will see that salutations will be removed from the cells.
This is how you can remove salutations from name cells in Excel.
Conclusion
In this tutorial, we have used a simple process to learn how you can remove salutations from name cells in Excel to highlight a particular set of data.
1K+ Views
