| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
missing text when using paste special from word to excel
When pasting a numbered list of interview responses from word to excel using
the paste special - text option I get one column with the number and one column with the text, which is what I need. However, in some cells, the text is cut short leaving me with responses that end in mid sentence. I'm using office 2003 products. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
missing text when using paste special from word to excel
Have you tried Format Cells/ Alignment/ Wap text?
How long are the text strings you are pasting in? -- David Biddulph "scottymoore14" wrote in message ... When pasting a numbered list of interview responses from word to excel using the paste special - text option I get one column with the number and one column with the text, which is what I need. However, in some cells, the text is cut short leaving me with responses that end in mid sentence. I'm using office 2003 products. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
missing text when using paste special from word to excel
I figured out that items that started "1. - Text" were being truncated for
some reason as a result of the leading dash. The length of the strings was not an issue as longer strings were intact as long as the dash was not present. Thank you for your response. "David Biddulph" wrote: Have you tried Format Cells/ Alignment/ Wap text? How long are the text strings you are pasting in? -- David Biddulph "scottymoore14" wrote in message ... When pasting a numbered list of interview responses from word to excel using the paste special - text option I get one column with the number and one column with the text, which is what I need. However, in some cells, the text is cut short leaving me with responses that end in mid sentence. I'm using office 2003 products. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Transfer data from Text Form Fields in MS Word into Excel? | Excel Discussion (Misc queries) | |||
| Paste Table from Word in Excel - 2000 -vs- 2002 | Excel Discussion (Misc queries) | |||
| moving text from a word document to excel | New Users to Excel | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| excel paste special should allow text | Excel Worksheet Functions | |||
Hybrid Mode
