Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 355
Default char(10) does not work to form a new line in my formula

i am merging a few cells into one, but want them to appear on 3 separate
lines. char(10) does not seem to be working.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: char(10) does not work to form a new line in my formula

If CHAR(10) is not working to create a new line in your formula, there are a few other things you can try.
  1. Use Alt+Enter: Instead of using CHAR(10), try using Alt+Enter. This keyboard shortcut will create a new line within the cell. To use it, simply type the first line of text, then press Alt+Enter and type the second line of text, and so on.
  2. Use CONCATENATE function: You can also use the CONCATENATE function to merge the cells and create new lines. Here's an example formula:
    Code:
    =CONCATENATE(A1,CHAR(10),B1,CHAR(10),C1)
    This formula will merge the values in cells A1, B1, and C1, and create a new line between each value.
  3. Use & symbol: Another way to merge cells and create new lines is to use the & symbol. Here's an example formula:
    Code:
    =A1&CHAR(10)&B1&CHAR(10)&C1
    This formula will merge the values in cells A1, B1, and C1, and create a new line between each value.

Try these alternatives and see if they work for you. If you have any other questions, feel free to ask!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default char(10) does not work to form a new line in my formula

You have to format the cell to wrap text.

A1:A3 = merged cells

Entered this formula:

="Line1"&CHAR(10)&"Line2"&CHAR(10)&"Line3"

Goto the menu FormatCellsAlignment tabWrap TextOK

The result of the formula appears as:

Line1
Line2
Line3

You may have to adjust the row height to get the exact fit you want.

--
Biff
Microsoft Excel MVP


"Sandy" wrote in message
...
i am merging a few cells into one, but want them to appear on 3 separate
lines. char(10) does not seem to be working.



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
formula with alpha char in cell soni Excel Discussion (Misc queries) 7 January 9th 09 05:04 PM
How do I get a line under my number that is just 1 char more? megan Excel Discussion (Misc queries) 2 September 22nd 08 06:20 PM
Excel 2007 - mixed type (line, column, stacked column) in one char Mike Charts and Charting in Excel 0 August 5th 08 06:33 PM
FIND 1 char in cell of any 3 char =True Nastech Excel Discussion (Misc queries) 5 April 26th 08 02:17 PM
8500 cells with phone number(7 char.), wishing to add area code (10 char.) [email protected] Excel Discussion (Misc queries) 6 March 10th 06 06:13 PM


All times are GMT +1. The time now is 10:39 AM.

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"