This will remove upto 4 extra spaces in Column A:
![]()
Sub JoeWalsh() With Range("A2:A" & ActiveSheet.UsedRange.Rows.count) .Replace " ", " ", xlPart .Replace " ", " ", xlPart .Replace " ", " ", xlPart .Replace " ", " ", xlPart End With End Sub
This will remove upto 4 extra spaces in Column A:
![]()
Sub JoeWalsh() With Range("A2:A" & ActiveSheet.UsedRange.Rows.count) .Replace " ", " ", xlPart .Replace " ", " ", xlPart .Replace " ", " ", xlPart .Replace " ", " ", xlPart End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks