| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
htm to xls
Hi,
When retrieving htm file and saving as xls, some cells contains text with " " in front of the text. I suspect that " " is a "blank" in htm. How can I remove the " " from the worksheet, so only the text remains? Best regards Jan holmstrom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
htm to xls
Click on A1 and:
Edit Replace in the replace what field enter:   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 " " in front of the text. I suspect that " " is a "blank" in htm. How can I remove the " " from the worksheet, so only the text remains? Best regards Jan holmstrom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 " " in front of the text. I suspect that " " is a "blank" in htm. How can I remove the " " from the worksheet, so only the text remains? Best regards Jan holmstrom |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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:   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 " " in front of the text. I suspect that " " is a "blank" in htm. How can I remove the " " from the worksheet, so only the text remains? Best regards Jan holmstrom |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 " " in front of the text. I suspect that " " is a "blank" in htm. How can I remove the " " from the worksheet, so only the text remains? Best regards Jan holmstrom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
