gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have the following formula that generates the following result
I need to remove any commas at the end because as cell AW171 (PACKAGED BEVERAGES) gets changed to something else the resulting values in the columns of 172 will not always be the same number of real values. Some categories have 2 or 3 sub categories while others have 10.
The end result would like this below where the string doesn't end in any commas.
Any ideas?
VBA Code:
=UPPER(AW171)&" - "&"including the following Subcategories" & PROPER(" - "&AW172&", "&AX172&", "&AY172&", "&AZ172&", "&BA172&", "&BB172&", "&BC172&", "&BD172&", "&BE172&", "&BF172&", "&BG172&", "&BH172&", "&BI172)
PACKAGED BEVERAGES - including the following Subcategories - Bottled Water, Carbonated Soft Drinks, Energy Drinks, Enhanced Water, Iced Tea Ready To Drink, Other Packaged Beverages, Sports Drinks, , , , , , |
I need to remove any commas at the end because as cell AW171 (PACKAGED BEVERAGES) gets changed to something else the resulting values in the columns of 172 will not always be the same number of real values. Some categories have 2 or 3 sub categories while others have 10.
The end result would like this below where the string doesn't end in any commas.
PACKAGED BEVERAGES - including the following Subcategories - Bottled Water, Carbonated Soft Drinks, Energy Drinks, Enhanced Water, Iced Tea Ready To Drink, Other Packaged Beverages, Sports Drinks |
Any ideas?