On 10/9/09 11:34 PM, in article ' wrote: I don't think you can. I am working on a Win7 VM running on a MAC, so I'm not sure if the alt key on my keyboard works differently. PLEASE HELP!!! What is the value that creates a carriage return? Thanks, but I can't seem to get that to work. I thought I bookmarked the page, but I can't find it again. I just recently moved over to the Mac and am dying not being able to do carriage returns within Excel. I am an Excel power user and do about 90% of my work in Excel. This is different from a carriage return or hard line break. If you hold down the 'Shift' key and press the 'Enter' key, you create a soft line break, also known as a shift-return.

'Does anyone know of any Excel 2003 VBA macro code that can remove carriage returns from the text values in cells? I foolishly thought I could have the macro do a Find and Replace, but I can't seem to get the macro to recognize a carriage return as the text to find. I've seen this in a file and the carriage return had a very weird effect on the cell contents, but I can't reproduce it manually. How do you enter a carriage return or CHAR(13) in a worksheet cell manually?I'm not talking about a line feed or CHAR(10). Select all cells where you want to remove or replace carriage returns.Please find the steps for eliminating line breaks using Find and Replace: Remove Carriage Returns manually Pros: the fastest way. 06.12.18 Excel For Mac How To Carriage Return In A Cell

Excel for mac soft return