We help IT Professionals succeed at work.

Is there a way of including a line feed (CHR(10)) in a formula of a cell ?

Tocogroup
Tocogroup asked
on
Hi,
I'd like to include a line feed within a CONCATENATE formula in a cell. I've tried...
=CONCATENATE(A3,CHR(10),B3)
but it ignores the line feed reference.
Any ideas
Toco
PS I don't want to use VBA to do this.
Comment
Watch Question

Try to wrap the text in a cell,

Format Cells ->Allignment -> Wrap Text

Sincerely,
Ed
Kamaraj SubramanianApplication Support Analyst

Commented:
Try with CHAR(10)
Try the following:
=CONCATENATE(A3,CHAR(10),B3)

or

=A3&CHAR(10)&B3

And you need to do the Wrap Text as I posted above.

Ed

Author

Commented:
Thanks for your help,
Tried both those solutions but they didn't work !
Any other ideas ?

Toco
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
They should both work - please post a sample where they do not.

Regards,
Rory

Author

Commented:
Thanks for this. It works fine.
Regards
Toco

Explore More ContentExplore courses, solutions, and other research materials related to this topic.