Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do I remove HTML markup from and cell.
i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I think this will get you most of the way the
EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for the quick reply.
I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have just tried that and it gives me the error message "formula to long"
"Stuart" wrote: Thanks for the quick reply. I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How many characters are in the cell? Is there something about the cell to
make Excel think it's a formula (plus sign, equal sign, etc)? (Anybody else have thoughts about this?) Does that help? *********** Regards, Ron "Stuart" wrote: I have just tried that and it gives me the error message "formula to long" "Stuart" wrote: Thanks for the quick reply. I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
OK...more information is good....but...
How about: Q: Are all 2500 products in one sheet? If yes, you don't have to Edit/Replace one at a time; you can click the [Replace all] button. Did you do that? Q: Are they all in one workbook? If yes, group the sheets together (Select the first sheet, hold down the [Shift] key, then select the last sheet). Then, do the same Edit/Replace as above. Q: Multiple workbooks? How many workbooks? If only a few, then use the above technique on each. If many...well...let's see if we need to cross that bridge. Does that help? *********** Regards, Ron "Stuart" wrote: Thanks for the quick reply. I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#7
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
All 2500 products are on one sheet, if you want an example i can give you an
example but it will take up alot off room in here and can out it on the server as a download so you can see what Im talking about Regards Stuart "Ron Coderre" wrote: OK...more information is good....but... How about: Q: Are all 2500 products in one sheet? If yes, you don't have to Edit/Replace one at a time; you can click the [Replace all] button. Did you do that? Q: Are they all in one workbook? If yes, group the sheets together (Select the first sheet, hold down the [Shift] key, then select the last sheet). Then, do the same Edit/Replace as above. Q: Multiple workbooks? How many workbooks? If only a few, then use the above technique on each. If many...well...let's see if we need to cross that bridge. Does that help? *********** Regards, Ron "Stuart" wrote: Thanks for the quick reply. I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#8
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
www.underonelink.com/help.xls
"Stuart" wrote: All 2500 products are on one sheet, if you want an example i can give you an example but it will take up alot off room in here and can out it on the server as a download so you can see what Im talking about Regards Stuart "Ron Coderre" wrote: OK...more information is good....but... How about: Q: Are all 2500 products in one sheet? If yes, you don't have to Edit/Replace one at a time; you can click the [Replace all] button. Did you do that? Q: Are they all in one workbook? If yes, group the sheets together (Select the first sheet, hold down the [Shift] key, then select the last sheet). Then, do the same Edit/Replace as above. Q: Multiple workbooks? How many workbooks? If only a few, then use the above technique on each. If many...well...let's see if we need to cross that bridge. Does that help? *********** Regards, Ron "Stuart" wrote: Thanks for the quick reply. I have over 2500 products to do so that would take some finding and replacing. Is there no formula or script that I can use to do this automatically. Regards Stuart "Ron Coderre" wrote: I think this will get you most of the way the EditReplace: Find What: <* Replace with: (this should be blank) Click the [Replace] button until you're sure it's doing what you want. Then, click the [Replace All] button. That will leave some extraneous spaces, so do another Find/Replace for double spaces and, again, replace them with nothing. Does that help? *********** Regards, Ron "Stuart" wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#9
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Since you're fixing a .csv file, maybe excel isn't the best choice.
If you visit shareware.com, you can find lots of programs to clean up HTML files. Stuart wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart -- Dave Peterson |
#10
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Not sure if I'm on the right track here with this suggestion ... If the HTML is being copied from the web, copy if to Notepad first, then copy from Notepad into Excel. Notepad will clean it up and get rid of the HTML code. Kaye On Tue, 22 Nov 2005 17:05:05 -0800, Stuart wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
#11
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The csv file is a database feed from our e-commerce site, so adding them one
by one to notepad to remove the html would take a long time. Regards Stuart "KC" wrote: Not sure if I'm on the right track here with this suggestion ... If the HTML is being copied from the web, copy if to Notepad first, then copy from Notepad into Excel. Notepad will clean it up and get rid of the HTML code. Kaye On Tue, 22 Nov 2005 17:05:05 -0800, Stuart wrote: How do I remove HTML markup from and cell. i.e. <DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0 <TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR <TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment </LI</UL</P</DIV I want it to read:- SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers dimensions: 75 x 46cm When using a changing mat on a dresser or other raised surface, never leave your baby unattended even for a moment I am trying to change out website csv file into a froogle csv file but without the HTML Thanks in advance Stuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
saving ppt as html | Excel Discussion (Misc queries) | |||
extract text from html files | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
save as html | Excel Discussion (Misc queries) | |||
html filter | Excel Discussion (Misc queries) |