EXCEL 2003: how to add CR or alt-enter using CONCATINATE function

M

MRHenn

i am trying to insert a carriage return or alt-enter in a cell in the
CONCATINATE function. CONCATINATE(a1, "-", b1, "(enter)") where enter is
the symbol i need to use. do not know what it is so it will force an CR or
alt-enter.
 

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

Exporting Data with Line Break 1
Excel - Wich Function should I use? 1
Object Browser in VBA 0
Want Enter to put CR in Textbox (not just CTRL-Enter) 7
Concatinate a function and make it work 5
Alt Enter Creates Tab Character 2
Embedding <CR>'s in formulas eases eye strain. 1
Cell value that changes previously entered value 9

Top