AndresHernando
asked on
Excel VBA - Make cell contents null if cell contains only spaces
How can I do the following w/ VBA:
1) For a given range, make contents of cell "null" if cell contains only spaces.
2) For a given range, replace multiple concatenated space characters with single space
Thanks, --Andres
1) For a given range, make contents of cell "null" if cell contains only spaces.
2) For a given range, replace multiple concatenated space characters with single space
Thanks, --Andres
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Petr, thanks for your input. I went with Rory's because it seems more straight forward and easier for me to understand.
Thanks again, --Andres