+ Reply to Thread
Results 1 to 2 of 2

Any function for Crop/Cut Text

  1. #1
    0-0 Wai Wai ^-^
    Guest

    Any function for Crop/Cut Text


    Hi.
    How can I do the following:
    - crop text from the left
    eg: CropText(A1, Crop3WordFromLeft)

    - crop text from the middle

    - crop text from the right

    - crop specific texts from left/middle/right
    eg: CropText(A1, Crop_'so to speak'_If_Found_from_right )


    If it is not possible, any workaround is appreciated.

    --
    Additional information:
    - I'm using Office XP
    - I'm using Windows XP



  2. #2
    Bernie Deitrick
    Guest

    Re: Any function for Crop/Cut Text

    Combinations of Replace, Left, Right, Mid, InStr, InStrRev, Split, etc. are usually how these are
    done. Post examples of before and after.

    HTH,
    Bernie
    MS Excel MVP


    "0-0 Wai Wai ^-^" <x@x.com> wrote in message news:%23jdOypFtFHA.2948@TK2MSFTNGP15.phx.gbl...
    >
    > Hi.
    > How can I do the following:
    > - crop text from the left
    > eg: CropText(A1, Crop3WordFromLeft)
    >
    > - crop text from the middle
    >
    > - crop text from the right
    >
    > - crop specific texts from left/middle/right
    > eg: CropText(A1, Crop_'so to speak'_If_Found_from_right )
    >
    >
    > If it is not possible, any workaround is appreciated.
    >
    > --
    > Additional information:
    > - I'm using Office XP
    > - I'm using Windows XP
    >
    >




+ 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