#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default excel cell to html

I am using Excel 2003
I have a cell that I paste in a description.
Lets say the cell looks like this:

This item is new.
It goes real fast.
Batteries not included.

I want a formula in another cell so the output would look like this:

This item is new. <br
It goes real fast. <br
Batteries not included. <br

Of course the description cell has a lot more info, but I'm mainly after a
cell that will put in the break "<br" at the end of every line in the cell
so it will somewhat look on a webpage like I got in the excel cell.

Thankyou for your help!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ms Excel, Copying Cell to current sheet using 'Right Click' SacSuggests Excel Discussion (Misc queries) 0 June 21st 06 08:26 AM
Remove html markup tags in an EXCEL cell? glennwhite Excel Discussion (Misc queries) 3 June 5th 06 07:25 AM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
It is a beautiful day - And I need help converting cell to html tryin2makeit2 Excel Discussion (Misc queries) 0 January 8th 06 07:41 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"