Burrgogi
Active Member
- Joined
- Nov 3, 2005
- Messages
- 487
- Office Version
- 2010
- Platform
- Windows
Hello, I have the following text in column D:
96% with 3335 reviews (Overwhelmingly Positive)
95% with 971 reviews (Overwhelmingly Positive)
84% with 6341 reviews (Very Positive)
88% with 4622 reviews (Very Positive)
73% with 157 reviews (Mostly Positive)
80% with 64 reviews (Positive)
Is there a macro that can examine the words in parenthesis and abbreviated in a separate column? for example: Take "Very Positive" from the text string and have it displayed as "VP" in a separate column.
(Just taking the first letter of each word). The only exception would be when the review is just "(Positive)" only -- see the very last line in the sample I provided above. In such a case, I would like to have it abbreviated as "Pos". If that latter part is too difficult, I'm happy to just settle for just the first letter of each word; OP, VP, MP.
I would like column C to contain the final result. Like so:
OP
OP
VP
VP
MP
Pos
96% with 3335 reviews (Overwhelmingly Positive)
95% with 971 reviews (Overwhelmingly Positive)
84% with 6341 reviews (Very Positive)
88% with 4622 reviews (Very Positive)
73% with 157 reviews (Mostly Positive)
80% with 64 reviews (Positive)
Is there a macro that can examine the words in parenthesis and abbreviated in a separate column? for example: Take "Very Positive" from the text string and have it displayed as "VP" in a separate column.
(Just taking the first letter of each word). The only exception would be when the review is just "(Positive)" only -- see the very last line in the sample I provided above. In such a case, I would like to have it abbreviated as "Pos". If that latter part is too difficult, I'm happy to just settle for just the first letter of each word; OP, VP, MP.
I would like column C to contain the final result. Like so:
OP
OP
VP
VP
MP
Pos
Last edited: