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!