Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Format Formula

CHAR(10) is the new line char, equiv. to pressing Alt+ENTER when you break
for a new line within a cell. (the wrap text formatting is still required for
it to work)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"enna49" wrote:
Works perfectly thanks for the quick response.
What is the CHAR(10)
Anne



 
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
formula to format Rick Excel Discussion (Misc queries) 5 January 5th 09 05:17 PM
sum format in formula bar LovestheBOSOX Excel Discussion (Misc queries) 3 June 5th 07 02:07 AM
Formula or Format Error?? DavidB New Users to Excel 3 October 17th 06 08:10 AM
Format\Formula Help scott Excel Worksheet Functions 7 April 14th 06 09:49 PM
format cell formula Juco New Users to Excel 4 February 13th 05 12:33 PM


All times are GMT +1. The time now is 07:13 AM.

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

About Us

"It's about Microsoft Excel"