Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell character extension
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Although I could not tell you what it is, I would bet there is an upper limit
on the number of characters you can put in a cell. There has to be some hardware limitations. I don't understand the advantage of putting all of your data into a single cell. It doesn't sound like a spreadsheet app is what you need. "R Smith" wrote: 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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
Cell 255 character limit and formula | Excel Worksheet Functions | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
identify data in a cell that has a number as the second character | Excel Worksheet Functions |