how do i format carriage returns for each cell in excel?
Hello,
I would like to format the columns of my excel spreadsheet to have carriage returns after the contents of each cell. I am trying to import this information into an AutoCad mText box, and if the excel cells do not have carriage returns, after I copy and paste the excel data into the mText box, I have to manually insert carriage returns. Any suggestions? Thank You, Laurel Hunter |
how do i format carriage returns for each cell in excel?
Programmatically, you could attach chr(13) to the end of the string
-- http://HelpExcel.com 516-984-0252 "Laurel Hunter" wrote: Hello, I would like to format the columns of my excel spreadsheet to have carriage returns after the contents of each cell. I am trying to import this information into an AutoCad mText box, and if the excel cells do not have carriage returns, after I copy and paste the excel data into the mText box, I have to manually insert carriage returns. Any suggestions? Thank You, Laurel Hunter |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com