Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default How do I start new line when concatenating text strings in excel?

How do I add a command to start a new line when concatenating text strings in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default How do I start new line when concatenating text strings in excel?

=A2&CHAR(10)&D2

Biff

"Max" wrote in message
...
How do I add a command to start a new line when concatenating text strings
in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)



  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default How do I start new line when concatenating text strings in excel?

Max

=A2&CHAR(10)&A5


Gord Dibben MS Excel MVP

On Wed, 25 Jan 2006 20:56:01 -0800, Max wrote:

How do I add a command to start a new line when concatenating text strings in
excel when referencing text cells?
e.g. cell A5 should contain =A2&?command?&D2 (Cell A5 is formatted for
word wrap)


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
Excel - merged cells w/wrapped text auto row height doesn't work. Fred Excel Discussion (Misc queries) 0 October 21st 05 02:11 PM
Text disappears when word wrap is used Mark_GS1CA Excel Discussion (Misc queries) 12 October 17th 05 12:44 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM
Bulleting text and spacing down a line in Excel Gord Dibben Excel Discussion (Misc queries) 0 January 24th 05 09:25 PM
How can I asign a number value to a text line in Excel? AIF_GoofyDo2 Charts and Charting in Excel 0 December 6th 04 01:19 AM


All times are GMT +1. The time now is 02:44 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"