Excel - carriage returns and formating of text within a cell

[mwaller]

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?

 

[מיכ×ל (מיקי) ×בידן]

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

 

[yclhk]

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