Excel - carriage returns and formating of text within a cell


M

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?
 
Ad

Advertisements

×

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

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
 
Ad

Advertisements

Y

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top