Add Chr(10) to cell

's Computer Specifications

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

's Computer Specifications

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

NickHK

"moonhk" <moon_ils-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

It works.

NickHK wrote:
> This ?
> =F29 & CHAR(10) & "(" & C29 & ")"
> You would also need to ensure that .WrapText = True for the cell.
>
> NickHK
>
> "moonhk" <moon_ils-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options	Yuvraj	Microsoft Excel Misc	0	29th Jun 2009 11:20 AM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4	tviola@wi.rr.com	Microsoft Excel Programming	1	21st Aug 2008 10:13 PM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4	tviola@wi.rr.com	Microsoft Excel Worksheet Functions	0	21st Aug 2008 08:44 PM
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON	CAPTGNVR	Microsoft Excel Programming	2	8th Jul 2007 04:18 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D	=?Utf-8?B?YWJtYjE2MQ==?=	Microsoft Excel Misc	5	26th Jan 2006 06:36 PM