Remove Extra Spaces from a Cell Value – Text VBA Macro

---

Left Trim
Description: This module will remove extra spaces from left side of selected cells. For e.g if a cell value is ”    excel    “ then after running the macro it will become “excel    “. (Notice spaces from left side has been removed.)

View VBA Macro Code Here

---

Right Trim
Description:This module will remove extra spaces from right side of selected cells. For e.g if a cell value is ”      excel   “ then after running the macro it will become ”     excel”. (Notice spaces from right side has been removed.)

View VBA Macro Code Here 

---

 Trim from Both sides
Description:This module will remove extra spaces from both sides of selected cells. For e.g if a cell value is ”      excel   “ then after running the macro it will become “excel”. (Notice spaces from both sides has been removed.)
View VBA Macro Code Here

---

Remove Extra Excessive Spaces
Description:This module will remove extra spaces from both sides and from inside the selected cells. For e.g if a cell value is ”      excel       items   “ then after running the macro it will become “excel items”. (Notice spaces from left , right and between excel and items words has been removed.)
View VBA Macro Code Here 

---

Change Case (Upper Case, Lower Case, Proper Case, Toggle and Sentence Case)

---

Change Text Case

---

UPPER CASE

Description: A word or sentence is said to be in upper case if its all the letters are in capital letters like this: EXCELITEMS IS BEST COLLECTION OF EXCEL RELATED STUFF.
View VBA Macro Code Here

---

lower case
 Description: A word or sentence is said to be in lower case if its all the letters are in small letters like this: excelitems is best collection of excel related stuff.
View VBA Macro Code Here

---

Proper Case 
Description: A word or sentence is said to be in proper case if first letter of each word is in capital letter and rest are in small letters like this: Excelitems Is Best Collection Of Excel Related Stuff.
View VBA Macro Code Here

---

Sentence case
Description: A sentence is said to be in sentence case if first letter of sentence is in capital letter and rest are in small letters like this: Excelitems is best collection of excel related stuff.
View VBA Macro Code Here

---

ToGgLe CaSe
Description: A word or sentence is said to be in toggle case if first letter of sentence is in capital letter and next is in small letter then next in capital letter and so on like this: ExCeLiTeMs iS BeSt cOlLeCtIoN Of eXcEl rElAtEd sTuFf.
View VBA Macro Code Here

---