Add Chr(10) to cell

M

moonhk

Dear All
How to add chr(10) into a cell formula ? The Cell will be a header
value.
=F29&" ("&C29&")" , cell value will be "Markup (0.05)"

In Other worksheet Header , I want column label is "Markup

(0.05 "

Moonhk
 
N

NickHK

This ?
=F29 & CHAR(10) & "(" & C29 & ")"
You would also need to ensure that .WrapText = True for the cell.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP!!! I can't set formula to cell 1
Userform textbox string to header causes unwanted double spacing 4
How to amend formula ? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Carriage Return Characters - Chr(10) 7
combobox, and chr(10) 7
MsgBox containing text from cell 5
Format a string before write to a cell 2

Top