Newline inside a Cell

Hi,

I want to insert a newline inside a cell using a formula.(similiar to ALT + Enter)

I have tried A2 & char(10) & B2. But this only gives a small square between them, and does not move the text to new line.

Could somebody help me on this. I am using VBA macros to inser the formulas.

Thanks for help in Advance

Regards
Anand

Originally Posted by anandmr65

Hi,

I want to insert a newline inside a cell using a formula.(similiar to ALT + Enter)

I have tried A2 & char(10) & B2. But this only gives a small square between them, and does not move the text to new line.

Could somebody help me on this. I am using VBA macros to inser the formulas.

Thanks for help in Advance

Regards
Anand

Please Login or Register  to view this content.

works for me
---