10-27-2005, 01:05 PM #1
How do I display html code within a cell?
I am importing data to a cell. The data is actually html code. I would like
to display the data formatted. Right now I get all the ugly html codes, like
Hello World.Thanks - John
10-27-2005, 01:05 PM #2
RE: How do I display html code within a cell?
You need to use Insert>Function and then select Hyperlink from the Lookup &<br /> Reference category.<br /> <br /> Randall Arnold<br /> <br /> "John-Raritan" wrote:<br /> <font color="blue"><br /> > I am importing data to a cell. The data is actually html code. I would like<br /> > to display the data formatted. Right now I get all the ugly html codes, like<br /> > <b> Hello World</>.<br /> ><br /> > Thanks - John</font><br /> </blockquote> </div> </div> </div> <div class="cleardiv"></div> </div> </div> <div class="postfoot"> <div class="textcontrols floatcontainer"> <span class="postcontrols" style="width:60%"> <img style="display:none" id="progress_1377610" src="//www.excelforum.com/images/misc/progress.gif" alt /> <a id="qrwq_5837" class="newreply" href="//www.excelforum.com/register.php" rel="nofollow"><img id="quoteimg_5837" src="//www.excelforum.com/clear.gif" alt="Reply With Quote" />Register To Reply</a> </span> <span class="postlinking"> </span> </div> </div> <hr /> </li> <li class="postbitlegacy postbitim postcontainer old" id="post_1378078"> <div class="posthead"> <span class="postdate old"> <span class="date">10-27-2005, <span class="time">06:05 PM</span></span> </span> <span class="nodecontrols"> <a name="post1378078" href="//www.excelforum.com/excel-general/479847-how-do-i-display-html-code-within-a-cell.html#post1378078" class="postcounter">#3</a><a id="postcount1378078" name="3"></a> </span> </div> <div class="postdetails"> <div class="userinfo"> <div class="username_container"> <span class="username guest">John-Raritan</span> </div> <span class="usertitle"> Guest </span> </div> <div class="postbody"> <div class="postrow"> <h2 class="title icon"> RE: How do I display html code within a cell? </h2> <div class="content"> <div id="post_message_1378078"> <blockquote class="postcontent restore "> <div style="float:right"> <script type="text/javascript"><!-- google_ad_client = "pub-8275723683113357"; /* excelforum 300x250 */ google_ad_slot = "9830241510"; google_ad_width = 300; google_ad_height = 250; //-->
Hướng dẫn how do you display text in html in excel? - làm thế nào để bạn hiển thị văn bản trong html trong excel?
The cell contains text that has html coding in it to achieve rich
formatting. Think email where body is in html. Right now the cell looks
ugly, eg Hello is displayed instead of a bold Hello. I would very
much like to just see a bold Hello.
If I undestood your suggestion correctly, it is for making some text be a
hyperlink.
Thanks - John
"Randall Arnold" wrote:
> You need to use Insert>Function and then select Hyperlink from the Lookup &
> Reference category.
>
> Randall Arnold
>
> "John-Raritan" wrote:
>
> > I am importing data to a cell. The data is actually html code. I would like
> > to display the data formatted. Right now I get all the ugly html codes, like
> > Hello World.
> >
> > Thanks - John
10-28-2005, 06:05 PM #4 Register To Reply
10-28-2005, 09:05 PM #5//groups.google.com/groups?thre...%40tkmsftngp02
and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
but it is only for copying formulas or text.
Somehow you have to get the HTML text into the Windows clipboard
as HTML.
Before getting carried away though keep in mind that a cell
can only have one link, and if it has a link you will see it all
as one link.
If it is just a matter of boldface then you could convert the strings
with something else that David Hager showed us - this is for
subscripts.
//groups.google.com/group/micro...ca9546cafd5127
Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
//groups.google.com/groups?thre...aroe%404ax.com
Converting what you have to HTML with my macro might work for you:
One way would be to convert the worksheet to HTML see
//www.mvps.org/dmcritchie/excel/xl2html.htm
which is a stupid macro and does not recognize most HTML code so it will be
simply transferred. Then copy and paste the generated HTML back to Excel.
You could convert just one column based on your selection then paste the
converted column back to your Excel sheet.
I have no idea if that would be an acceptable solution. But this is the way that
I create most of my tables for my Excel documentation. I just tested it with
your example and [just boldface tags] and it worked fine. Converting only one
column and then copying and pasting back from HTML [using Internet Explorer]
would get you around having to preserve any formulas in the other columns.
BTW, your subject is ambiguous it looks like it means the opposite of what you
are asking for, and I'd have a hard time rephrasing it myself. Perhaps
How to convert HTML formatting tags to format data within Excel
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
Search Page: //www.mvps.org/dmcritchie/excel/search.htm
"FinRazel" wrote ...
> How much data are you talking about? Instead of using Import, could you use
> copy/paste? If you can, simply Paste Special and click the HTML radio button.
>
> > > "John-Raritan" wrote:
> > > > I am importing data to a cell. The data is actually html code. I would like
> > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > Hello World. .....
> > > >
and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
but it is only for copying formulas or text.
Somehow you have to get the HTML text into the Windows clipboard
as HTML.
Before getting carried away though keep in mind that a cell
can only have one link, and if it has a link you will see it all
as one link.
If it is just a matter of boldface then you could convert the strings
with something else that David Hager showed us - this is for
subscripts.
//groups.google.com/group/micro...ca9546cafd5127
Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
//groups.google.com/groups?thre...aroe%404ax.com
Converting what you have to HTML with my macro might work for you:
One way would be to convert the worksheet to HTML see
//www.mvps.org/dmcritchie/excel/xl2html.htm
which is a stupid macro and does not recognize most HTML code so it will be
simply transferred. Then copy and paste the generated HTML back to Excel.
You could convert just one column based on your selection then paste the
converted column back to your Excel sheet.
I have no idea if that would be an acceptable solution. But this is the way that
I create most of my tables for my Excel documentation. I just tested it with
your example and [just boldface tags] and it worked fine. Converting only one
column and then copying and pasting back from HTML [using Internet Explorer]
would get you around having to preserve any formulas in the other columns.
BTW, your subject is ambiguous it looks like it means the opposite of what you
are asking for, and I'd have a hard time rephrasing it myself. Perhaps
How to convert HTML formatting tags to format data within Excel
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
Search Page: //www.mvps.org/dmcritchie/excel/search.htm
"FinRazel" wrote ...
> How much data are you talking about? Instead of using Import, could you use
> copy/paste? If you can, simply Paste Special and click the HTML radio button.
>
> > > "John-Raritan" wrote:
> > > > I am importing data to a cell. The data is actually html code. I would like
> > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > Hello World. .....
> > > >
10-29-2005, 01:05 PM #6//groups.google.com/groups?thre...%40tkmsftngp02
>
> and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
> but it is only for copying formulas or text.
>
> Somehow you have to get the HTML text into the Windows clipboard
> as HTML.
>
> Before getting carried away though keep in mind that a cell
> can only have one link, and if it has a link you will see it all
> as one link.
>
> If it is just a matter of boldface then you could convert the strings
> with something else that David Hager showed us - this is for
> subscripts.
> //groups.google.com/group/micro...ca9546cafd5127
> Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
> //groups.google.com/groups?thre...aroe%404ax.com
>
>
> Converting what you have to HTML with my macro might work for you:
> One way would be to convert the worksheet to HTML see
> //www.mvps.org/dmcritchie/excel/xl2html.htm
> which is a stupid macro and does not recognize most HTML code so it will be
> simply transferred. Then copy and paste the generated HTML back to Excel.
>
> You could convert just one column based on your selection then paste the
> converted column back to your Excel sheet.
>
> I have no idea if that would be an acceptable solution. But this is the way that
> I create most of my tables for my Excel documentation. I just tested it with
> your example and [just boldface tags] and it worked fine. Converting only one
> column and then copying and pasting back from HTML [using Internet Explorer]
> would get you around having to preserve any formulas in the other columns.
>
> BTW, your subject is ambiguous it looks like it means the opposite of what you
> are asking for, and I'd have a hard time rephrasing it myself. Perhaps
> How to convert HTML formatting tags to format data within Excel
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: //www.mvps.org/dmcritchie/excel/search.htm
>
> "FinRazel" wrote ...
> > How much data are you talking about? Instead of using Import, could you use
> > copy/paste? If you can, simply Paste Special and click the HTML radio button.
> >
> > > > "John-Raritan" wrote:
> > > > > I am importing data to a cell. The data is actually html code. I would like
> > > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > > Hello World. .....
> > > > >
>
>
>
>
>
> and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
> but it is only for copying formulas or text.
>
> Somehow you have to get the HTML text into the Windows clipboard
> as HTML.
>
> Before getting carried away though keep in mind that a cell
> can only have one link, and if it has a link you will see it all
> as one link.
>
> If it is just a matter of boldface then you could convert the strings
> with something else that David Hager showed us - this is for
> subscripts.
> //groups.google.com/group/micro...ca9546cafd5127
> Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
> //groups.google.com/groups?thre...aroe%404ax.com
>
>
> Converting what you have to HTML with my macro might work for you:
> One way would be to convert the worksheet to HTML see
> //www.mvps.org/dmcritchie/excel/xl2html.htm
> which is a stupid macro and does not recognize most HTML code so it will be
> simply transferred. Then copy and paste the generated HTML back to Excel.
>
> You could convert just one column based on your selection then paste the
> converted column back to your Excel sheet.
>
> I have no idea if that would be an acceptable solution. But this is the way that
> I create most of my tables for my Excel documentation. I just tested it with
> your example and [just boldface tags] and it worked fine. Converting only one
> column and then copying and pasting back from HTML [using Internet Explorer]
> would get you around having to preserve any formulas in the other columns.
>
> BTW, your subject is ambiguous it looks like it means the opposite of what you
> are asking for, and I'd have a hard time rephrasing it myself. Perhaps
> How to convert HTML formatting tags to format data within Excel
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: //www.mvps.org/dmcritchie/excel/search.htm
>
> "FinRazel" wrote ...
> > How much data are you talking about? Instead of using Import, could you use
> > copy/paste? If you can, simply Paste Special and click the HTML radio button.
> >
> > > > "John-Raritan" wrote:
> > > > > I am importing data to a cell. The data is actually html code. I would like
> > > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > > Hello World. .....
> > > > >
>
>
>
>
10-31-2005, 12:05 PM #7//groups.google.com/groups?thre...%40tkmsftngp02
> >
> > and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
> > but it is only for copying formulas or text.
> >
> > Somehow you have to get the HTML text into the Windows clipboard
> > as HTML.
> >
> > Before getting carried away though keep in mind that a cell
> > can only have one link, and if it has a link you will see it all
> > as one link.
> >
> > If it is just a matter of boldface then you could convert the strings
> > with something else that David Hager showed us - this is for
> > subscripts.
> > //groups.google.com/group/micro...ca9546cafd5127
> > Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
> > //groups.google.com/groups?thre...aroe%404ax.com
> >
> >
> > Converting what you have to HTML with my macro might work for you:
> > One way would be to convert the worksheet to HTML see
> > //www.mvps.org/dmcritchie/excel/xl2html.htm
> > which is a stupid macro and does not recognize most HTML code so it will be
> > simply transferred. Then copy and paste the generated HTML back to Excel.
> >
> > You could convert just one column based on your selection then paste the
> > converted column back to your Excel sheet.
> >
> > I have no idea if that would be an acceptable solution. But this is the way that
> > I create most of my tables for my Excel documentation. I just tested it with
> > your example and [just boldface tags] and it worked fine. Converting only one
> > column and then copying and pasting back from HTML [using Internet Explorer]
> > would get you around having to preserve any formulas in the other columns.
> >
> > BTW, your subject is ambiguous it looks like it means the opposite of what you
> > are asking for, and I'd have a hard time rephrasing it myself. Perhaps
> > How to convert HTML formatting tags to format data within Excel
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: //www.mvps.org/dmcritchie/excel/search.htm
> >
> > "FinRazel" wrote ...
> > > How much data are you talking about? Instead of using Import, could you use
> > > copy/paste? If you can, simply Paste Special and click the HTML radio button.
> > >
> > > > > "John-Raritan" wrote:
> > > > > > I am importing data to a cell. The data is actually html code. I would like
> > > > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > > > Hello World. .....
> > > > > >
> >
> >
> >
> >
> >
> > and Chip Pearson's //www.cpearson.com/excel/clipboar.htm
> > but it is only for copying formulas or text.
> >
> > Somehow you have to get the HTML text into the Windows clipboard
> > as HTML.
> >
> > Before getting carried away though keep in mind that a cell
> > can only have one link, and if it has a link you will see it all
> > as one link.
> >
> > If it is just a matter of boldface then you could convert the strings
> > with something else that David Hager showed us - this is for
> > subscripts.
> > //groups.google.com/group/micro...ca9546cafd5127
> > Gord Dibben had an example boldfacing and/or coloring characters within a cell Oct 2002
> > //groups.google.com/groups?thre...aroe%404ax.com
> >
> >
> > Converting what you have to HTML with my macro might work for you:
> > One way would be to convert the worksheet to HTML see
> > //www.mvps.org/dmcritchie/excel/xl2html.htm
> > which is a stupid macro and does not recognize most HTML code so it will be
> > simply transferred. Then copy and paste the generated HTML back to Excel.
> >
> > You could convert just one column based on your selection then paste the
> > converted column back to your Excel sheet.
> >
> > I have no idea if that would be an acceptable solution. But this is the way that
> > I create most of my tables for my Excel documentation. I just tested it with
> > your example and [just boldface tags] and it worked fine. Converting only one
> > column and then copying and pasting back from HTML [using Internet Explorer]
> > would get you around having to preserve any formulas in the other columns.
> >
> > BTW, your subject is ambiguous it looks like it means the opposite of what you
> > are asking for, and I'd have a hard time rephrasing it myself. Perhaps
> > How to convert HTML formatting tags to format data within Excel
> > ---
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: //www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: //www.mvps.org/dmcritchie/excel/search.htm
> >
> > "FinRazel" wrote ...
> > > How much data are you talking about? Instead of using Import, could you use
> > > copy/paste? If you can, simply Paste Special and click the HTML radio button.
> > >
> > > > > "John-Raritan" wrote:
> > > > > > I am importing data to a cell. The data is actually html code. I would like
> > > > > > to display the data formatted. Right now I get all the ugly html codes, like
> > > > > > Hello World. .....
> > > > > >
> >
> >
> >
> >
07-25-2012, 09:28 AM #8milindm7
- View Profile
- View Forum Posts
+ Reply to Thread
« Previous Thread | Next Thread »
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. [0 members and 1 guests]
Bookmarks
Bookmarks
- Digg
- del.icio.us
- StumbleUpon
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
- BB code is On
- Smilies are On
- [IMG] code is Off
- HTML code is Off
- Trackbacks are Off
- Pingbacks are Off
- Refbacks are Off
Forum Rules
URL thân thiện với công cụ tìm kiếm của VBSEO 3.6.0 RC 1
Làm cách nào để hiển thị văn bản trong HTML trong Excel?
Mở bảng tính chứa HTML Bạn sẽ chuyển đổi thành văn bản, sau đó nhấn các phím ALT + F11 để mở cửa sổ Microsoft Visual Basic cho các ứng dụng. 2. Trong cửa sổ Microsoft Visual Basic cho các ứng dụng, nhấp vào Chèn> Mô -đun, sau đó sao chép bên dưới mã VBA vào cửa sổ Mô -đun. 3.
Làm cách nào để hiển thị dữ liệu từ Excel đến HTML?
Với sổ làm việc mà bạn muốn lưu dưới dạng tệp HTML mở trong Excel, trong ruy băng, chọn Tệp> Lưu dưới dạng ...
Từ danh sách thả xuống bên dưới tên tệp, chọn trang web [ *. HTM, *. HTML] và sau đó nhấp vào Lưu ..
Tệp sau đó sẽ được lưu dưới dạng tệp HTML.Chuyển sang Windows Explorer để xem tệp HTML ..
Làm thế nào để bạn làm html trong excel?
Trên menu tệp, nhấp vào Nhập.Trong hộp thoại Nhập, nhấp vào tùy chọn cho loại tệp bạn muốn nhập, sau đó nhấp vào Nhập.Trong hộp thoại Chọn tệp, định vị và nhấp vào tệp CSV, HTML hoặc văn bản mà bạn muốn sử dụng làm phạm vi dữ liệu bên ngoài, sau đó nhấp vào Nhận dữ liệu.
Bạn có thể viết HTML trong Excel không?
Tạo mã HTML và IFRAME.Sử dụng các công thức trong Excel để tạo mã HTML hoặc IFRAME, sau đó thêm vào trang web hoặc bài đăng trên blog, để hiển thị liên kết hoặc video được nhúng.Nhận sổ làm việc miễn phí, để xem các công thức hoạt động như thế nào.Use formulas in Excel to create HTML or IFRAME code, then add to a web page or blog post, to show links or embedded videos. Get the free workbook, to see how the formulas work.