Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Ed Sheehan Ed Sheehan is offline
external usenet poster
 
Posts: 14
Default Automated way to merge and remove hard returns in a column

I have created a table from a report. One column has many words, which wrap
into several rows during 'convert text to table,' while all the other
columns could fit on one row, as shown in Fig. A. I would like to end up
like Fig. B, but It's a real PITA to do the merges and return-removals
manually. Anyone got a solution? I'm happy to massage the data externally if
necessary.

|COLUMN1 |COLUMN2 |COLUMN3 |
|----------|------------|----------|
|Few Words |Many many wo|Few Words |
|----------|------------|----------|
| |rds are in t| |
|----------|------------|----------| Fig. A
| |his column, | |
|----------|------------|----------|
| |and they hav| |
|----------|------------|----------|
| |e hard retur| |
|----------|------------|----------|
| |ns embedded | |
|----------|------------|----------|
| |for every ro| |
|----------|------------|----------|
| |w. | |
|----------|------------|----------|

================================================== ===

|COLUMN1 |COLUMN2 |COLUMN3 |
|----------|------------|----------|
|Few Words |Many many wo|Few Words |
| |rds are in t| | Fig. B
| |his column, | |
| |and they hav| |
| |e hard retur| |
| |ns embedded | |
| |for every ro| |
| |w. | |

|----------|------------|----------|

Thanks, Ed


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove background highlighting form merge fields DD Mailmerge 2 July 8th 06 06:18 AM
How do I remove highlighting in the merge field on a mail merge? Donnaw Mailmerge 1 February 9th 06 04:56 AM
Hard returns in an If-Then-Else statement Bryan L Mailmerge 2 November 30th 05 08:29 PM
How to remove mail merge from a new starting document? Aideesg New Users 1 September 10th 05 06:53 AM
How to remove unwanted formatting in mail merge for cells witn no Jim Mailmerge 3 March 4th 05 08:13 AM


All times are GMT +1. The time now is 10:28 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"