htm to xls
 

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

htm to xls
 

Click on A1 and:

Edit Replace
in the replace what field enter:
&nbsp

and then click replace all.
--
Gary''s Student - gsnu200834


"Jan Holmstrom" wrote:

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

htm to xls
 

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

htm to xls
 

Hi Again "Gary"s Student.

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

Best regards
Jan

"Gary''s Student" skrev:

Click on A1 and:

Edit Replace
in the replace what field enter:
&nbsp

and then click replace all.
--
Gary''s Student - gsnu200834


"Jan Holmstrom" wrote:

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

htm to xls
 

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