htm to xls

J

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
 
G

Gary''s Student

Click on A1 and:

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

and then click replace all.
 
P

Per Jessen

Hi Jan

Use Find/Replace from the Edit menu.

Find "Your String" and replace with blank.

Best regards,
Per
 
J

Jan Holmstrom

Hi Again "Gary"s Student.

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

Best regards
Jan

"Gary''s Student" skrev:
 
J

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF, SUM and INDIRECT Help 4
If function across sheets prints value of cell 4
capture webbrowser navigation events (not a question, but solution) 1
Run-time error ‘13’ mismatch type 1
Help with very repetitive task in excel...is there an answer? 4
How do I align a label so it is positioned right in front of a dropdownlist in asp 1
Regex syntax request for help 3
How to open large HTML FILES IN EXCEL In quick Time 1

Top