| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a character paste limit per cell?
I get information (text) sent to me in an excel workbook from a coworker that
I have to copy and paste into another excel file to create a database for use with pivot tables, etc. But when I paste info into new workbook, not all the information is there. I've been double clicking each incomplete cell, copying and then double clicking the cell in new worksheet and pasting. There's got to be a better way. Can anyone help me? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a character paste limit per cell?
Excel 2007 - Total number of characters that a cell can contain = 32,767
characters -- If this post helps click Yes --------------- Peggy Shepard "JAH" wrote: I get information (text) sent to me in an excel workbook from a coworker that I have to copy and paste into another excel file to create a database for use with pivot tables, etc. But when I paste info into new workbook, not all the information is there. I've been double clicking each incomplete cell, copying and then double clicking the cell in new worksheet and pasting. There's got to be a better way. Can anyone help me? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a character paste limit per cell?
Our company used excel 2003. There's no other way?
"pshepard" wrote: Excel 2007 - Total number of characters that a cell can contain = 32,767 characters -- If this post helps click Yes --------------- Peggy Shepard "JAH" wrote: I get information (text) sent to me in an excel workbook from a coworker that I have to copy and paste into another excel file to create a database for use with pivot tables, etc. But when I paste info into new workbook, not all the information is there. I've been double clicking each incomplete cell, copying and then double clicking the cell in new worksheet and pasting. There's got to be a better way. Can anyone help me? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a character paste limit per cell?
You're getting the information as an excel file?
If yes,make sure you open both the sending and receiving file in the same instance of excel. JAH wrote: I get information (text) sent to me in an excel workbook from a coworker that I have to copy and paste into another excel file to create a database for use with pivot tables, etc. But when I paste info into new workbook, not all the information is there. I've been double clicking each incomplete cell, copying and then double clicking the cell in new worksheet and pasting. There's got to be a better way. Can anyone help me? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a character paste limit per cell?
Dave... you are a life-saver.
I've been opening 2 different instances of excel and working that way for more than a year. Thank you so much for the great advice. J "Dave Peterson" wrote: You're getting the information as an excel file? If yes,make sure you open both the sending and receiving file in the same instance of excel. JAH wrote: I get information (text) sent to me in an excel workbook from a coworker that I have to copy and paste into another excel file to create a database for use with pivot tables, etc. But when I paste info into new workbook, not all the information is there. I've been double clicking each incomplete cell, copying and then double clicking the cell in new worksheet and pasting. There's got to be a better way. Can anyone help me? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a character limit within a cell? | Excel Discussion (Misc queries) | |||
| Character limit in cell | Excel Discussion (Misc queries) | |||
| Character limit per cell | Excel Discussion (Misc queries) | |||
| Cell 255 character limit and formula | Excel Worksheet Functions | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
Linear Mode
