Cell Limitations ? Formatting and Size when exporting to Tab based Text file?
 

I am running into a problem copying information into a cell within my
spreadsheet. I am a novice when it comes to working in excel, I
normally do graphics work for the company I work for. My boss would
like me to update their excel spreadsheet that is provided to Froogle
for shopping.

The sheet I am using has worked in the past with the exception of
containing item descriptions. Since the item descriptions are searched
able we would like to be able to add them for each product.

The problem I am running into is that the data I need has to be copied
from a page on our website. The page contains formatting like header
sizes, bold, bullets etc. It is also a large amount of text, I would
guess about 10,000-15,000 words on average.

When I copy the text and try to paste it into a cell in my spreadsheet
the cell expands and throws off the alignment of the entire spreadsheet
making it next to impossible to read. I have pasted a smaller item
description in the line above which worked good. [it was about 1
paragraph of text.]

The biggest thing we are concerned about is that once we have updated
the spread sheet and are ready to host it to Froogle it cannot contain
any formatting since it will be exported to a tab based text file. I
have tried copying the description and pasting it into notepad to
remove formatting, I have tried the program “Pure Text” and the Windows
key + Ctrl V trick. No matter what I seem to do it does not seem to be
compatible with the cell. [the closest I was able to get was the text
with hollow squares which I believe represent the “Enter” or “Tab” key
?]

I was wondering if this is possibly a limitation of excel or if there
is an option I am missing. I have tried double clicking the cell and
just pasting text. Single clicking the cell and using the “Paste
Special” option. I have checked in cell format, and nothing seems to be
working for me. Any advice you can offer is greatly appreciated. Thanks…


--
PaulH_1980
------------------------------------------------------------------------
PaulH_1980's Profile: http://www.excelforum.com/member.php...o&userid=32493
View this thread: http://www.excelforum.com/showthread...hreadid=522835

Cell Limitations ? Formatting and Size when exporting to Tab based Text file?
 

You cannot have any "forced returns", "forced line breaks."
When EXCEL "sees" a forced return or line break - it will add anything
following the line into a NEW CELL.
In WORD you can do a FIND and REPLACE, use ^p for carriage returns
(paragraph marks) and ^l for a forced line break. You can also find
these in the REPLACE Menu, under the MORE-SPECIAL tab.
In the replace box just hit the spacebar - and this will insert a
space.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=522835