ExcelBanter - Add Chr(10) to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Add Chr(10) to cell (https://www.excelbanter.com/excel-programming/377899-add-chr-10-cell.html)

moonhk

Add Chr(10) to cell

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

NickHK

Add Chr(10) to cell

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

moonhk

Add Chr(10) to cell

It works.

NickHK wrote:
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

All times are GMT +1. The time now is 03:41 AM.