i have a worksheet when copying info from a text file and pasting to the
spreadsheet the info is not transferred. The file is 2740 lines with 221940
characters. What is the limintation on characters for a cell and can you
extend the limitation to accomadate this info for a cell.

try importing the data.

click Data/Get External Data/Import Text File

this will open the import wizard. step through it and select the options
you need.


"R Smith" wrote:

i have a worksheet when copying info from a text file and pasting to the
spreadsheet the info is not transferred. The file is 2740 lines with 221940
characters. What is the limintation on characters for a cell and can you
extend the limitation to accomadate this info for a cell.

when importing data into worksheet it puts al the info in multiple cells
instead of one single cell. Expample i have a file that has a 672 lines with
data and if i try to add it in one single cell nothing happens. if i import
the data from a file to worksheet in imports it ok but add it to 672 cells
instead of one cell.

"JMB" wrote:

try importing the data.

click Data/Get External Data/Import Text File

this will open the import wizard. step through it and select the options
you need.


"R Smith" wrote:

i have a worksheet when copying info from a text file and pasting to the
spreadsheet the info is not transferred. The file is 2740 lines with 221940
characters. What is the limintation on characters for a cell and can you
extend the limitation to accomadate this info for a cell.