LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 6
Default Concatenate and Line Breaks

Hi,

Normally, we can use Alt+Enter to add a line break to text we type into a single cell. Is something like this possible with the concatenate function?

I'd like to take texts from several different cells and put them together in one cell with line breaks where I want them.
 
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
How do I use a formula to create a new line of text in a cell? Jon Shelton Excel Worksheet Functions 2 July 19th 06 06:00 PM
Creating a concatenate text list by referencing an array nothingbutjeep Excel Discussion (Misc queries) 0 May 30th 06 09:46 PM
Using concatenate to include a line return dan Excel Discussion (Misc queries) 1 January 26th 06 01:52 PM
concatenate, force new line JohnT Excel Worksheet Functions 2 March 6th 05 04:05 PM
How do I insert a line break when using the CONCATENATE function? ShaneRuth Excel Worksheet Functions 2 November 5th 04 11:26 PM


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

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

About Us

"It's about Microsoft Excel"