Enter carriage return in Excel 2010 text string

L

LoydC

I am trying to input a text string with a carriage return or break s
the second part shows on a separate line. Other threads hav
demonstrated the use of CHAR(10) but that is not working for me. Here i
my code:
=K2&CHAR(10)&" "&TEXT(C2,"mm/dd/yyyy")&" @ "&D2

Anyone have any ideas what I need to change to get it to work properly
 
C

Claus Busch

Hi,

Am Tue, 31 Dec 2013 14:37:41 +0000 schrieb LoydC:
=K2&CHAR(10)&" "&TEXT(C2,"mm/dd/yyyy")&" @ "&D2
Click to expand...

right click in your cell => Format cells => Alignment => Wrap Text [x]

Regards
Claus B.
 

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

Similar Threads

Select text before carriage return 2
Carriage returns - how to get rid of them (again) 8
Bold items within text string 7
Carriage Return within Cell for MAC users 0
Carriage return in text box. 2
How do I return text in between char(10) 1
carriage return that works when pasted into a text file (eg. Notep 3
Returning the month (mmm) from cell in date format dd/mm/yyyy 3

Top