+ Reply to Thread
Results 1 to 3 of 3

Find and Replace Macro

  1. #1
    Registered User
    Join Date
    10-17-2005
    Posts
    40

    Find and Replace Macro

    Hello
    I have a situation that is not all that uncommon, I am scanning in documents that I wrote long ago and don't have digitally. The problem is that when it is done OCRing the documents they are not in paragraph form and I would like them to be. I can manually go through and remove line breaks but that is a pain. I was hoping to write a macro to take care of most of it.

    Fortunately each new line begins with either a bold title or the whole line is italics so there is an easy way to diferenciate between the lines. However the line breaks themselves are not affected by the following character's format and so I can't figure out how to do a find routine to pick them out.

    Here is what the text looks like with
    TITLE
    some italics text
    Heading: Text here
    Heading: Text here

    TITLE

    With Title and Heading both being bold and the section saying "some italics here" being italics. If anyone has an idea on how to make this go faster for me I would appreciate it.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Your problem discription sounds like you are discribing a Word document

    This is an Excel only forum
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Registered User
    Join Date
    10-17-2005
    Posts
    40
    You are very right, I have a few links all in the same folder for forums for help with stuff and I wasn't paying attention to the names or the heading on the pages. Sorry about that.

+ 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