ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting HTML into a single cell (https://www.excelbanter.com/excel-discussion-misc-queries/91095-pasting-html-into-single-cell.html)

tg550

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


Dave Peterson

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

tg550

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


Dave Peterson

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

tg550

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



All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com