I need to fix this Remove Extra space and Asterisk by automatically vba code or any formula. I have a large worksheet with 1500 rows like this.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]unsorted descriptions[/TD]
[TD]Fixed description[/TD]
[/TR]
[TR]
[TD][TABLE="width: 439"]
<tbody>[TR]
[TD]Yellow Citrine studs, real gemstone post earrings gift for woman, bridesmaids earrings - 14 K Gold filled earrings minimalist jewelry.
Classic minimalist Citrine gemstone earrings,
Citrine is a yellow-to-golden member of the quartz mineral group , Citrine is known as the lucky
stone for getting money
Also being used by healers to - promote clarity of thought, increase self esteem.
Sources of citrine include Brazil, Bolivia, several African countries and parts of the Soviet Union.
Size : 10.68 mm, 0.42 mm
Weight : 0.09 g (0.3 oz )
Materials : Citrine gem stone natural, 14 k gold filled setting
Hand set with prongs to secure the stone .
Earring Backs - silicon
This are 100% natural stones, the stones may vary slightly in shape, size and color.
The Stones are hand set in secure prongs.
World wide flat shipping .
-Ready to ship 1-3 days, delivery speed 10 - 16 business days to the U.S.A ,U.K, Australia, Spain, France, Canada, Netherlands ( Fri Sat Sun and
-
-
Made with love
Petite delights
Ilona
Item Sku: EAQY613
** **[TABLE="width: 439"]
<tbody>[TR]
[TD]** **[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 439"]
<tbody>[TR]
[TD]Yellow Citrine studs, real gemstone post earrings gift for woman, bridesmaids earrings - 14 K Gold filled earrings minimalist jewelry.
Classic minimalist Citrine gemstone earrings,
Citrine is a yellow-to-golden member of the quartz mineral group , Citrine is known as the lucky
stone for getting money
Also being used by healers to - promote clarity of thought, increase self esteem.
Sources of citrine include Brazil, Bolivia, several African countries and parts of the Soviet Union.
Size : 10.68 mm, 0.42 mm
Weight : 0.09 g (0.3 oz )
Materials : Citrine gem stone natural, 14 k gold filled setting
Hand set with prongs to secure the stone .
Earring Backs - silicon
This are 100% natural stones, the stones may vary slightly in shape, size and color.
The Stones are hand set in secure prongs.
Made with love
Petite delights
Ilona
Item Sku: EAQY613[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]unsorted descriptions[/TD]
[TD]Fixed description[/TD]
[/TR]
[TR]
[TD][TABLE="width: 439"]
<tbody>[TR]
[TD]Yellow Citrine studs, real gemstone post earrings gift for woman, bridesmaids earrings - 14 K Gold filled earrings minimalist jewelry.
Classic minimalist Citrine gemstone earrings,
Citrine is a yellow-to-golden member of the quartz mineral group , Citrine is known as the lucky
stone for getting money
Also being used by healers to - promote clarity of thought, increase self esteem.
Sources of citrine include Brazil, Bolivia, several African countries and parts of the Soviet Union.
Size : 10.68 mm, 0.42 mm
Weight : 0.09 g (0.3 oz )
Materials : Citrine gem stone natural, 14 k gold filled setting
Hand set with prongs to secure the stone .
Earring Backs - silicon
This are 100% natural stones, the stones may vary slightly in shape, size and color.
The Stones are hand set in secure prongs.
World wide flat shipping .
-Ready to ship 1-3 days, delivery speed 10 - 16 business days to the U.S.A ,U.K, Australia, Spain, France, Canada, Netherlands ( Fri Sat Sun and
-
-
Made with love
Petite delights
Ilona
Item Sku: EAQY613
** **[TABLE="width: 439"]
<tbody>[TR]
[TD]** **[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 439"]
<tbody>[TR]
[TD]Yellow Citrine studs, real gemstone post earrings gift for woman, bridesmaids earrings - 14 K Gold filled earrings minimalist jewelry.
Classic minimalist Citrine gemstone earrings,
Citrine is a yellow-to-golden member of the quartz mineral group , Citrine is known as the lucky
stone for getting money
Also being used by healers to - promote clarity of thought, increase self esteem.
Sources of citrine include Brazil, Bolivia, several African countries and parts of the Soviet Union.
Size : 10.68 mm, 0.42 mm
Weight : 0.09 g (0.3 oz )
Materials : Citrine gem stone natural, 14 k gold filled setting
Hand set with prongs to secure the stone .
Earring Backs - silicon
This are 100% natural stones, the stones may vary slightly in shape, size and color.
The Stones are hand set in secure prongs.
Made with love
Petite delights
Ilona
Item Sku: EAQY613[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
