View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bcraig505 bcraig505 is offline
external usenet poster
 
Posts: 1
Default How do I insert a line feed in a formula?

If you wish to copy and paste the concatenated result into an email body and
not loose the line returns try this.

=CONCATENATE($A1,CHAR(13),$B1)

Good luck.



"TX_KniveS" wrote:

I'm trying to insert a line feed (or carriage return) into a text formula I
have in a cell. I'm trying to concatenate text entered into two other cells
in this new cell and have the two entries on a different line within the same
cell. Anybody know how to do this?