sweater_vests_rock
Well-known Member
- Joined
- Oct 8, 2004
- Messages
- 1,657
I have data that comes into a sheet like
CountryCode | DateLastAccessed |
I would like to insert spaces before each capitalized letter. in the example,
Country Code | Date Last Accessed |
I've thought about using the Chr code in VBA, looping through each string, but I feel like this could be handled with more finesse. Ideas?
Thanks. Ben.
CountryCode | DateLastAccessed |
I would like to insert spaces before each capitalized letter. in the example,
Country Code | Date Last Accessed |
I've thought about using the Chr code in VBA, looping through each string, but I feel like this could be handled with more finesse. Ideas?
Thanks. Ben.