| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - carriage returns and formating of text within a cell
Text pasted into a cell from Word or other software will keep the formats
including carriage returns, line numbers, tabs, etc. Can text be typed into a cell with control characters that will force this type of formating? -- mwaller |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - carriage returns and formating of text within a cell
If I understood your question correctly - you might try hitting Alt+Enter in
order to go to a new line in the same cell Micky "mwaller" wrote: Text pasted into a cell from Word or other software will keep the formats including carriage returns, line numbers, tabs, etc. Can text be typed into a cell with control characters that will force this type of formating? -- mwaller |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - carriage returns and formating of text within a cell
Try as following :
Format the designated cell to the format you expected in Excel, for example, bold, red Copy the text from other software, in Excel : edit - paste special - select "text" - click "paste" - OK The text would paste to the designated cell with the format you set. yclhk "mwaller" wrote: Text pasted into a cell from Word or other software will keep the formats including carriage returns, line numbers, tabs, etc. Can text be typed into a cell with control characters that will force this type of formating? -- mwaller |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unicode text and carriage returns | Excel Discussion (Misc queries) | |||
| Importing Text with Carriage Returns inside cell values | Excel Discussion (Misc queries) | |||
| how do i format carriage returns for each cell in excel? | Excel Discussion (Misc queries) | |||
| How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
| How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
