LinkBack URL
About LinkBacks
Hai all,
While i getting values from mysql and loading them into an excel file,i came across line breaks and stucked... \n ,\r\n not working....can anyone explain the line break syntax in excel and openoffice calc..???
Line break like \n in Excel while loading database values into excel
Hai all,
While i getting values from mysql and loading them into an excel file,i came across line breaks and stucked... \n ,\r\n not working....can anyone explain the line break syntax in excel and openoffice calc..???
Within a cell, you can line break with Alt+Enter.
You could also concatenate char(10), but you will need to make sure Word Wrap is enabled.
Example: ="chennai"&char(10)&"is"&char(10)&"awesome" would appear as
chennai
is
awesome
in a single cell, if Word Wrap in enabled.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Yeah...it's working...thanks alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks