Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ShaneRuth
 
Posts: n/a
Default How do I insert a line break when using the CONCATENATE function?

I want to combine text into a single cell but I want the text to be stacked
vertically not in a line.
  #2   Report Post  
Tom Hayakawa
 
Posts: n/a
Default

Use char(10).

Example:

=CONCATENATE("How",CHAR(10),"now,",CHAR(10),"brown cow?")

Good luck,

Tom Hayakawa

"ShaneRuth" wrote:

I want to combine text into a single cell but I want the text to be stacked
vertically not in a line.

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Shane

=A1 & CHAR(10) & A2 & CHAR(10) & A3......on and on

Format to "wrap text"

Gord Dibben Excel MVP

On Fri, 5 Nov 2004 11:09:02 -0800, ShaneRuth
wrote:

I want to combine text into a single cell but I want the text to be stacked
vertically not in a line.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Can I change the Insert Function button to an equals sign? Jokeyjojo Excel Discussion (Misc queries) 1 January 17th 05 06:45 PM
Insert Function "FX" on Toolbar in Excel Rich Excel Discussion (Misc queries) 4 January 16th 05 04:04 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"