Text in next line inside a cell Report

[thilag]

Dear Friends

I attached a excel file <Report Forum.xlsx>.

In that file I want to generate a report in Cell B10, by using the datas in the cells A3 to B8 (the Entries in the A3 to A8 will be constant and the Entries in the B3 to B8 will gets changed each and every report).

Now i generate a report myself in the cell B10, but the problem is i want a report which looks like B12 where entries are seperated and looks good which can be readily used. Please help me.

Thanks in Advance

thilag

[benishiryo]

hi thilag. CHAR(10) gives you the same effect of ALT + ENTER. so add in wherever you need to. and because you need to press ALT + ENTER twice, you need to repeat CHAR(10) twice by using REPT or just type in another CHAR(10)

Please Login or Register  to view this content.

[thilag]

Thanks benishiryo

this suits my correct requirement.

thilag