help_for_excel
Board Regular
- Joined
- Feb 24, 2012
- Messages
- 72
Hi,
I have two strings In Excel and I want to write a macro
1st string:
xxxxxxx;xxx;d:ffff;.ffff;color:green;'>•</span
"<DIV><span style='font-weight:bold; font-size:24px;color:green;'>•</span></DIV>"
2nd String:
<DIV><span style='font-weight:bold; font-size:13px; font-family:Symbol;'><sup>®</sup></span> <span style='font-weight:bold; font-size:24px;color:green'>•</span></DIV>
"<DIV><span style='font-weight:bold; font-size:13px; font-family:Symbol;'><sup>®</sup></span> <span style='font-weight:bold; font-size:24px;color:green'>•</span></DIV>"
I want to write a macro in which, macro picks up the color green from 1st string and color green from second string and out put result in the format
output:
color green small dot(Symbol) → (Symbol) color green small dot(Symbol)
and ignore rest of the text
I have two strings In Excel and I want to write a macro
1st string:
xxxxxxx;xxx;d:ffff;.ffff;color:green;'>•</span
"<DIV><span style='font-weight:bold; font-size:24px;color:green;'>•</span></DIV>"
2nd String:
<DIV><span style='font-weight:bold; font-size:13px; font-family:Symbol;'><sup>®</sup></span> <span style='font-weight:bold; font-size:24px;color:green'>•</span></DIV>
"<DIV><span style='font-weight:bold; font-size:13px; font-family:Symbol;'><sup>®</sup></span> <span style='font-weight:bold; font-size:24px;color:green'>•</span></DIV>"
I want to write a macro in which, macro picks up the color green from 1st string and color green from second string and out put result in the format
output:
color green small dot(Symbol) → (Symbol) color green small dot(Symbol)
and ignore rest of the text