help_for_excel
Board Regular
- Joined
- Feb 24, 2012
- Messages
- 72
Hi
String 1: "bold:yes";color:green;font >12; chart =no, graphic = bad
String 2: "bold:yes";color
urple;font >100; chart =no, graphic = bad
String 3: "bold:no";font >8; chart =no, graphic = very good;color:brown
my question is I want VBA code or excel formula which outputs
color:green
color
urple
color:brown
I know Mid function can be used but I am having trouble handling it. As color can appear anywhere in the string and I want whole things "Color: green"
Please help, thanks in advance
String 1: "bold:yes";color:green;font >12; chart =no, graphic = bad
String 2: "bold:yes";color

String 3: "bold:no";font >8; chart =no, graphic = very good;color:brown
my question is I want VBA code or excel formula which outputs
color:green
color

color:brown
I know Mid function can be used but I am having trouble handling it. As color can appear anywhere in the string and I want whole things "Color: green"
Please help, thanks in advance