htm to xls

[Jan Holmstrom]

Hi,

When retrieving htm file and saving as xls, some cells contains text with
"&nbsp" in front of the text. I suspect that "&nbsp" is a "blank" in htm.

How can I remove the "&nbsp" from the worksheet, so only the text remains?

Best regards
Jan holmstrom

 

[Gary''s Student]

Click on A1 and:

Edit > Replace >
in the replace what field enter:
&nbsp

and then click replace all.

 

[Per Jessen]

Hi Jan

Use Find/Replace from the Edit menu.

Find "Your String" and replace with blank.

Best regards,
Per

 

[Jan Holmstrom]

Hi Again "Gary"s Student.

I've just tried it - and it worked. Thanks

Best regards
Jan

"Gary''s Student" skrev:

 

[Jan Holmstrom]

Hi Per,

Thank you for the answer. I've just tried in the VBA recorder and it worked.

Thanks.

Best regards
Jan

"Per Jessen" skrev: