Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tg550
 
Posts: n/a
Default Pasting HTML into a single cell


I want to paste a LOT of HTML code into a single cell in a CSV document
but it keeps spilling over. It can't be rectified with edit - fill -
justify. Is there any way i can do this?

cheers


--
tg550
------------------------------------------------------------------------
tg550's Profile: http://www.excelforum.com/member.php...o&userid=34906
View this thread: http://www.excelforum.com/showthread...hreadid=546466

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Pasting HTML into a single cell

Try pasting directly into the formula bar (with the correct cell selected).

tg550 wrote:

I want to paste a LOT of HTML code into a single cell in a CSV document
but it keeps spilling over. It can't be rectified with edit - fill -
justify. Is there any way i can do this?

cheers

--
tg550
------------------------------------------------------------------------
tg550's Profile: http://www.excelforum.com/member.php...o&userid=34906
View this thread: http://www.excelforum.com/showthread...hreadid=546466


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
tg550
 
Posts: n/a
Default Pasting HTML into a single cell


sorry i should have said before i tried that but the computer just
bleeps. Presumably too much data to paste?


--
tg550
------------------------------------------------------------------------
tg550's Profile: http://www.excelforum.com/member.php...o&userid=34906
View this thread: http://www.excelforum.com/showthread...hreadid=546466

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Pasting HTML into a single cell

Each cell can hold about 32k characters.

How much data are you pasting?

tg550 wrote:

sorry i should have said before i tried that but the computer just
bleeps. Presumably too much data to paste?

--
tg550
------------------------------------------------------------------------
tg550's Profile: http://www.excelforum.com/member.php...o&userid=34906
View this thread: http://www.excelforum.com/showthread...hreadid=546466


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
tg550
 
Posts: n/a
Default Pasting HTML into a single cell


About 100K. Is there any way of increasing the amount a cell can take?

Thanks for your help. Sorry it took so long to get back to you my
emails where blocked


--
tg550
------------------------------------------------------------------------
tg550's Profile: http://www.excelforum.com/member.php...o&userid=34906
View this thread: http://www.excelforum.com/showthread...hreadid=546466

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
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Cell Reference's when Pasting RadiantQuartzHeater Excel Discussion (Misc queries) 0 February 16th 06 08:55 AM
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
how do i set up a single cell continual entry in excel to total f. mike@swallow Excel Discussion (Misc queries) 1 December 7th 04 12:29 PM


All times are GMT +1. The time now is 12:41 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"