LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I insert a hard break (alt enter) in a concatenated string

I'm trying to insert a break at a particular point in text that is combined
using concatenate. The text is being used as column headings and I was hoping
to have some consistency in appearance to make the information easier to
read. The length of the pieces of combined text are of differing lengths. The
column widths are generally the same but do occasionally vary.

Any ideas?
 
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
Auto-Insert Line Break (Alt+Enter)? o1darcie1o Excel Discussion (Misc queries) 4 October 25th 06 08:29 PM
Splitting a concatenated string into separate rows... Natarajan Excel Worksheet Functions 1 May 4th 06 05:57 PM
How do I break up a concatenated text string ? Bhobhojani Gudo Excel Discussion (Misc queries) 2 March 3rd 06 07:57 AM
Bold a portion of concatenated string joeeng Excel Discussion (Misc queries) 1 December 8th 05 08:26 PM
specify range name in formula with concatenated string Lori H Excel Worksheet Functions 2 July 19th 05 03:07 PM


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