P
PaulH_1980
I am running into a problem copying information into a cell within m
spreadsheet. I am a novice when it comes to working in excel,
normally do graphics work for the company I work for. My boss woul
like me to update their excel spreadsheet that is provided to Froogl
for shopping.
The sheet I am using has worked in the past with the exception o
containing item descriptions. Since the item descriptions are searche
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 copie
from a page on our website. The page contains formatting like heade
sizes, bold, bullets etc. It is also a large amount of text, I woul
guess about 10,000-15,000 words on average.
When I copy the text and try to paste it into a cell in my spreadshee
the cell expands and throws off the alignment of the entire spreadshee
making it next to impossible to read. I have pasted a smaller ite
description in the line above which worked good. [it was about
paragraph of text.]
The biggest thing we are concerned about is that once we have update
the spread sheet and are ready to host it to Froogle it cannot contai
any formatting since it will be exported to a tab based text file.
have tried copying the description and pasting it into notepad t
remove formatting, I have tried the program “Pure Text” and the Window
key + Ctrl V trick. No matter what I seem to do it does not seem to b
compatible with the cell. [the closest I was able to get was the tex
with hollow squares which I believe represent the “Enter” or “Tab” ke
?]
I was wondering if this is possibly a limitation of excel or if ther
is an option I am missing. I have tried double clicking the cell an
just pasting text. Single clicking the cell and using the “Past
Special” option. I have checked in cell format, and nothing seems to b
working for me. Any advice you can offer is greatly appreciated. Thanks
spreadsheet. I am a novice when it comes to working in excel,
normally do graphics work for the company I work for. My boss woul
like me to update their excel spreadsheet that is provided to Froogl
for shopping.
The sheet I am using has worked in the past with the exception o
containing item descriptions. Since the item descriptions are searche
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 copie
from a page on our website. The page contains formatting like heade
sizes, bold, bullets etc. It is also a large amount of text, I woul
guess about 10,000-15,000 words on average.
When I copy the text and try to paste it into a cell in my spreadshee
the cell expands and throws off the alignment of the entire spreadshee
making it next to impossible to read. I have pasted a smaller ite
description in the line above which worked good. [it was about
paragraph of text.]
The biggest thing we are concerned about is that once we have update
the spread sheet and are ready to host it to Froogle it cannot contai
any formatting since it will be exported to a tab based text file.
have tried copying the description and pasting it into notepad t
remove formatting, I have tried the program “Pure Text” and the Window
key + Ctrl V trick. No matter what I seem to do it does not seem to b
compatible with the cell. [the closest I was able to get was the tex
with hollow squares which I believe represent the “Enter” or “Tab” ke
?]
I was wondering if this is possibly a limitation of excel or if ther
is an option I am missing. I have tried double clicking the cell an
just pasting text. Single clicking the cell and using the “Past
Special” option. I have checked in cell format, and nothing seems to b
working for me. Any advice you can offer is greatly appreciated. Thanks