combine text from 2 cells into 1, result has 2 lines

S

scorcher

i need to combine 2 cells with text formatting into one cell. the new
cell needs to have 2 lines of text. the text from the first referenced
cell must be on the first line and the text from the second referenced
cell must be on the second line. this needs to be done without using
text wrap formatting or manually using alt enter.

example:

A1 contains:
this is the text in A1

A2 contains:
this is the text in A2

A3 would combine A1 and A2 to read:
this is the text in A1
this is the text in A2



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------
 

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