Title: Unnecessary Blank Characters in Cells in Excel 2010
Headings: Unnecessary Blank Characters in Cells in Excel 2010
Unnecessary Blank Characters in Cells in Excel 2010
Previous

Content: Cell A2 contains the text“Excel Tips”
Enter the formula in cell B2 =TRIM (A2), press Enter on your keyboard
The function will return the text after deleting the unnecessary spaces. Let’s take an example to understand how and where we can use TRIM function. For Example:- We have 2 data sets, 1 st data is having all details, and we want the 2 nd data to pick the date of joining, by using the Employee name. Employee names are with spaces, and we will use here TRIM function along with Vlookup function. Follow below given steps:-
Write the formula in cell F2. =VLOOKUP (TRIM (E3),A2: B7,2,FALSE)
Press Enter on your keyboard. The function will return Date of Joining for agent. Copy the formula by pressing the key Ctrl+C and paste in the range F3: F7 by pressing the key Ctrl+V on your keyboard.