ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i format carriage returns for each cell in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/108540-how-do-i-format-carriage-returns-each-cell-excel.html)

Laurel Hunter

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



galimi

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