How can I get excell to ignore line breaks?

[Guest]

I need to be able to have html source in a cell in Excel. My html source has
line breaks and blank lines that I'd like to keep in tact. Is there a way to
do this?

Long explanation: I have to create a file with product information and then
save this in a tab delimited file for import into a shopping cart system.
There are quite a few fields and all of them are simple except the
description field. For the descriptions I have written the html in such a
way that you can actually read it ;-), and I'd like to keep it that way (with
the line breaks and blank lines and spaces at beginnings of lines, etc). So
if I can't do this in Excel, is there another product that I could use that
could create a tab delimited file?

 

[David McRitchie]

Hi Linda,
A tab delimited, or a comma separated values, by definition do not have
any formatting by definition.

But you indicate having html source in Excel, and that is not clear to me
what you have or want . What you start with, where it is to be stored.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[Guest]

Thank you David!

I have HTML source that I would like to put into excel. This source has
line breaks but no tabs.

So for example, I'd like to put the following into a single cell in excel
and not lose my linebreaks or beginning line spaces:

--------------------------
<p>Here is some information.

<ul>
<li>one item of relevance
<li>two item of relevance
</ul>

-----------------------------

Is this possible? Or would you recommend some other tool to do this?

Thank you,
Linda

Hi Linda,
A tab delimited, or a comma separated values, by definition do not have
any formatting by definition.

But you indicate having html source in Excel, and that is not clear to me
what you have or want . What you start with, where it is to be stored.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I need to be able to have html source in a cell in Excel. My html source has
line breaks and blank lines that I'd like to keep in tact. Is there a way to
do this?

Long explanation: I have to create a file with product information and then
save this in a tab delimited file for import into a shopping cart system.
There are quite a few fields and all of them are simple except the
description field. For the descriptions I have written the html in such a
way that you can actually read it ;-), and I'd like to keep it that way (with
the line breaks and blank lines and spaces at beginnings of lines, etc). So
if I can't do this in Excel, is there another product that I could use that
could create a tab delimited file?

 

[David McRitchie]

Hi Linda,
Surprised that it works, but select a single cell, and paste to the
formula bar.

Pasting to the formula bar you will get your spacing formatting,
but no other formatting, and of course no links.

Just in case you are really trying to end up with HTML
in a cell, you can only have one link in a cell anyway,
because a link is assigned to a cell or to an object but not
to word(s) within a cell. .

Does this really do what you want?
..

Thank you David!

I have HTML source that I would like to put into excel. This source has
line breaks but no tabs.

So for example, I'd like to put the following into a single cell in excel
and not lose my linebreaks or beginning line spaces:

--------------------------
<p>Here is some information.

<ul>
<li>one item of relevance
<li>two item of relevance
</ul>

-----------------------------

Is this possible? Or would you recommend some other tool to do this?

Thank you,
Linda

Hi Linda,
A tab delimited, or a comma separated values, by definition do not have
any formatting by definition.

But you indicate having html source in Excel, and that is not clear to me
what you have or want . What you start with, where it is to be stored.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I need to be able to have html source in a cell in Excel. My html source has
line breaks and blank lines that I'd like to keep in tact. Is there a way to
do this?

Long explanation: I have to create a file with product information and then
save this in a tab delimited file for import into a shopping cart system.
There are quite a few fields and all of them are simple except the
description field. For the descriptions I have written the html in such a
way that you can actually read it ;-), and I'd like to keep it that way (with
the line breaks and blank lines and spaces at beginnings of lines, etc). So
if I can't do this in Excel, is there another product that I could use that
could create a tab delimited file?