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

NickHK

"moonhk" wrote in message
oups.com...
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