You can read more about it here( or get VBA code): https://www.excelhow.net/remove-leadi...
This Excel video tutorial, we'll explore two methods to remove leading and trailing spaces from your data. We'll start with a simple formula-based approach using the TRIM function, followed by a more advanced method using VBA code.
Time Stamps
00:00:17 Method1: Remove Leading and Trailing Spaces using Formula
00:02:04 Method2: Remove Leading and Trailing Spaces using VBA
#########
Learn Microsoft Excel Online Free: https://excelhow.net/
#########