+ Reply to Thread
Results 1 to 5 of 5

Remove all "to " from selected area

  1. #1
    Forum Contributor
    Join Date
    11-12-2007
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    472

    Remove all "to " from selected area

    Hello,

    i have to remove "to " from a list of word which is very large. I hope some one here can help me here.

    Its a dictionary and some of the verbs in the meaning field have "to " with them and some dont. Now i want to delet all "to "s from the list so that all the verbs are unitedly with out "to ". The seperator is ";".An example:

    to throw;to cause to fall;to knock over
    to fall down;purler;fall;downfall
    to go to;me to go
    go there;to go to;go
    mento green
    to go to hell

    should become:

    throw;cause to fall;knock over
    fall down;purler;fall;downfall
    go to;me to go
    go there;go to;go
    mento green
    go to hell

    Not every "to " is to be deleted but only those which are at the beginning of a word. For example "to go to hell" will become "go to hell". And "mento green" will remain the way it is.

    Thanks for each help in advance
    Attached Files Attached Files
    Last edited by wali; 04-27-2010 at 09:12 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Remove all "to " from selected area

    Does it have to be code?

    =SUBSTITUTE(IF(LEFT(A1,3)="to ",MID(A1,4,LEN(A1)),A1),";to ",";")
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    11-12-2007
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    472

    Re: Remove all "to " from selected area

    not not at all! a formula would work as well. Could you please paste the formula in the example excel table of mine and upload it? Unfortunately its not running here with me because i dont haver english excel.
    thanks

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Remove all "to " from selected area

    You need to change the comma separators into semi-colon separators if you are using non english.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-12-2007
    Location
    Germany
    MS-Off Ver
    2007
    Posts
    472

    Re: Remove all "to " from selected area

    You are great! thank you very much. You saved me at least two months of work! thanks

+ 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