Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 210
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In EXCEL 2002 format cell with existing data. greg1090 Excel Discussion (Misc queries) 1 July 19th 06 10:51 PM
Can Excel 2003 cell link carry with it the source cell format? tom Excel Discussion (Misc queries) 2 July 14th 06 06:14 AM
I cannot edit cell format in Excel 2000 (Part of office 2000)! Brett Excel Discussion (Misc queries) 1 April 12th 06 05:58 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"