#1   Report Post  
KatoKat
 
Posts: n/a
Default Line breaks

I have a huge report that contains the following columns. Box number and box
content description. My problem is the description field contains multiple
entries seperated by a carriage return / line break. Box #0001 has 3 entries
for it's description. Box #0002 has 2 entries. What I need to end up with is
3 "rows" of Box #0001 each with it's own seperated text string. And 2 "rows"
of Box #0002 with it's seperated text strings. Please Help
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

If you're looking to insert a line break within an individual cell, use:
<Alt <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"KatoKat" wrote in message
...
I have a huge report that contains the following columns. Box number and box
content description. My problem is the description field contains multiple
entries seperated by a carriage return / line break. Box #0001 has 3 entries
for it's description. Box #0002 has 2 entries. What I need to end up with is
3 "rows" of Box #0001 each with it's own seperated text string. And 2 "rows"
of Box #0002 with it's seperated text strings. Please Help

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 and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 05:42 AM
Changing Line in line chart B Dubinsky Charts and Charting in Excel 1 January 21st 05 05:10 AM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 01:43 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


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