Line breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
==============================================

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Data 1
Link Access to Excel export back to excel 3
Hyperlink Formula Problem 2
Insert and propagate Rows - based on a format rule 4
Query filtering by Aggregate 3
Creating Id 8
how do I find all the rows containing a specific value in excel 1
count of unique values within a column 7

Back
Top