+ Reply to Thread
Results 1 to 2 of 2

Find/Replace with Manual Line Break

  1. #1
    Registered User
    Join Date
    12-19-2006
    Posts
    1

    Find/Replace with Manual Line Break

    I have a very large Word table that I need to convert to Excel. The Word table has individual cells that contain multiple paragraphs. Whether I do a straight copy/paste to Excel or import external data, it puts each paragraph in a separate cell. Replacing the paragraph marks in Word with a manual line break and then pasting into Excel produces the same result.

    I did a find/replace in Word changing to paragraph marks to a special character (in this case @) and it pastes very well into Excel. Now I need to do a find/replace in Excel that replaces the @ sign with a manual line break. I entered "alt 010" (minus quotes) in the replace field. This displays nothing in the dialog box but when you run the replace, it does replace the @ signs in the smaller cells. Unfortunately, the cells where there are multiple paragraphs returns an error saying "Formula is too long." I tried creating a macro to do this but it isn't working correctly either.

    Any ideas?

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    I can remember incredible headaches when exporting from Word to Excel...
    The best solution is to code your word macro to clean data from table cells before export ...
    Please Login or Register  to view this content.
    HTH
    Carim

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1