Hi there,
Hoping some guru can help me modify a VBA. I have a column that collapsed all the text, removing spaces. However there are capital letters throughout the string that can make the field more readable if I add a space before. I am using the code below, which works nicely, but the issue I am running into is where an acroymn is listed (in all caps) it is adding a space before each letter by design. How can I get it to ignore subsequent caps. For example, if my original string was
SCUBADivingIsMyFavoritePastime
the code adjusts to
S C U B A Diving Is My Favorite Pastime
where i'd like to have it as
SCUBA Diving Is My Favorite Pastime
the acronym may be in the beginning, middle, or end and there may be more than one in the string, any thoughts? Thanks in advance
Bookmarks