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/
------------------------------------------------
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/
------------------------------------------------