Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell merge/formatting (Excel/Word XP)

    I don't know if this is a Word or Excel question. I have an Excel spreadsheet and am trying to convert the cells to text so I can paste it into Crystal Reports. I'm copying the cells from Excel into Word and then doing a Merge Cells to get rid of the lines. Is there a way to do this but have it place tab stops where the table lines were so I don't have to reformat all of it to look the same (without the cell lines)?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cell merge/formatting (Excel/Word XP)

    You can export to a tab-delimited text file directly from Excel (File | Save As...)
    Or you can paste the table into Word, select the entire table, then select Table | Convert | Table to Text..., and specify Tab as delimiter.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Cell merge/formatting (Excel/Word XP)

    I'm sorry if I'm being thick here, but is what you want to do just to paste a block of information into Crystal without the lines that Excel puts round it? Because if so, you've only got to remove the lines in Excel before copying and then paste the block in ...

    I assume I must be missing something here? If so, please let me know what exactly you want to do in Crystal and I'll try again ...!
    Beryl M


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •