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 ".
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ritesh DiyawarPosted Jan 19, 2011, 7:32 AM
masood aliPosted Jan 19, 2011, 3:09 AM
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*