Pasting HTML into a single cell

[tg550]

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

[Dave Peterson]

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]

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

[Dave Peterson]

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]

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