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:

Hi Jan

Use Find/Replace from the Edit menu.

Find "Your String" and replace with blank.

Best regards,
Per

"Jan Holmstrom" skrev i meddelelsen
...
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