'Keep Trailing Spaces in Column Text
Is there a way to make Excel keep the trailing spaces in a column or selection? I need 16 spaces, exactly, but excel keeps removing them, unless I put a non-whitespace character. I can't get it to stick.
Dim c as Range
For Each c In Selection
if c.Value <> "" Then c.value = c.value & Space(16)
Next
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|