V
Vertigo
I was hoping I could get some assistance in writing a VBA macro that could help me perform what would be the most mundane task, but I've come to find out the task is time sensitive and needs to be completed ASAP.
I have 5243 cells that contains data formatted like the example below.
FEATURES:
• Color-Coded sizes.
• Elastic design provides constant tension.
• Vinyl coated steel hooks and woven polyester strap cover will not mar finish.
• Use for securing loads on cars, trucks, trailers, and more.
What I need to achieve here is the following:
FEATURES:
<ul><li>Color-Coded sizes.</li>
<li>Elastic design provides constant tension.</li>
<li>Vinyl coated steel hooks and woven polyester strap cover will not mar finish.</li>
<li>Use for securing loads on cars, trucks, trailers, and more.</li></ul>
Essentially the first bullet point needs to get <ul><li> tags to start. TheLAST bullet point in the list needs to end with </li></ul> tags. Every line in between needs to be wrapped with <li></li> tags. I'm not sure if this can be achieved in running one single macro or if multiple would be needed to achieve this result. Thanks for the help.
I have 5243 cells that contains data formatted like the example below.
FEATURES:
• Color-Coded sizes.
• Elastic design provides constant tension.
• Vinyl coated steel hooks and woven polyester strap cover will not mar finish.
• Use for securing loads on cars, trucks, trailers, and more.
What I need to achieve here is the following:
FEATURES:
<ul><li>Color-Coded sizes.</li>
<li>Elastic design provides constant tension.</li>
<li>Vinyl coated steel hooks and woven polyester strap cover will not mar finish.</li>
<li>Use for securing loads on cars, trucks, trailers, and more.</li></ul>
Essentially the first bullet point needs to get <ul><li> tags to start. TheLAST bullet point in the list needs to end with </li></ul> tags. Every line in between needs to be wrapped with <li></li> tags. I'm not sure if this can be achieved in running one single macro or if multiple would be needed to achieve this result. Thanks for the help.