AScii Value of Alt+Enter for inserting into cell in excel.

Question

Hi Experts i exported data from the database and exported into excel(datatable to excel ) but some column have new line character and they ccreate a problem so i want to know value of Alt+Enter  .

Ritesh Diyawar · Answer

sorry this is not working

masood ali · Answer

10 is the Extended ASCII value for ALT+ENTER You can replace new line characters in Excel with Use Replace with  while entering  ensure that numlock is set to  on on your keyboard then holding down the Alt key type: 10 on the number pad . Try it .. it may work. ***Masood*** *Always Rocks*