+ Reply to Thread
Results 1 to 6 of 6

remove characters from a text under a condition

  1. #1
    elaine216@gmail.com
    Guest

    remove characters from a text under a condition

    Hello,

    I know if you want to remove the last X characters, you can do it by

    =left(A1,(len(A1)-X))


    I want to remove any characters from a text that is longer than 35
    characters.
    ie, I want to remove characters 36th and onwards.

    How can I do it?

    Thanks.
    Elaine.


  2. #2
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    Try =left(A1, 35)

  3. #3
    David Biddulph
    Guest

    Re: remove characters from a text under a condition

    <elaine216@gmail.com> wrote in message
    news:1149521497.819560.324010@g10g2000cwb.googlegroups.com...
    > Hello,
    >
    > I know if you want to remove the last X characters, you can do it by
    >
    > =left(A1,(len(A1)-X))
    >
    > I want to remove any characters from a text that is longer than 35
    > characters.
    > ie, I want to remove characters 36th and onwards.
    >
    > How can I do it?


    =LEFT(A1,35)

    Did you look at Excel's help to see what the LEFT function does?
    --
    David Biddulph



  4. #4
    CLR
    Guest

    RE: remove characters from a text under a condition

    =LEFT(A1,$F$1) and type whatever number of characters you want to keep in
    cell F1

    Vaya con Dios,
    Chuck, CABGx3



    "elaine216@gmail.com" wrote:

    > Hello,
    >
    > I know if you want to remove the last X characters, you can do it by
    >
    > =left(A1,(len(A1)-X))
    >
    >
    > I want to remove any characters from a text that is longer than 35
    > characters.
    > ie, I want to remove characters 36th and onwards.
    >
    > How can I do it?
    >
    > Thanks.
    > Elaine.
    >
    >


  5. #5
    elaine216@gmail.com
    Guest

    Re: remove characters from a text under a condition

    yeah sure!!
    cant believe i didnt know"

    thank so much!


    CLR wrote:

    > =LEFT(A1,$F$1) and type whatever number of characters you want to keep in
    > cell F1
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    >
    > "elaine216@gmail.com" wrote:
    >
    > > Hello,
    > >
    > > I know if you want to remove the last X characters, you can do it by
    > >
    > > =left(A1,(len(A1)-X))
    > >
    > >
    > > I want to remove any characters from a text that is longer than 35
    > > characters.
    > > ie, I want to remove characters 36th and onwards.
    > >
    > > How can I do it?
    > >
    > > Thanks.
    > > Elaine.
    > >
    > >



  6. #6
    CLR
    Guest

    Re: remove characters from a text under a condition

    Happy to help...........

    Vaya con Dios,
    Chuck, CABGx3



    "elaine216@gmail.com" wrote:

    > yeah sure!!
    > cant believe i didnt know"
    >
    > thank so much!
    >
    >
    > CLR wrote:
    >
    > > =LEFT(A1,$F$1) and type whatever number of characters you want to keep in
    > > cell F1
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > >
    > > "elaine216@gmail.com" wrote:
    > >
    > > > Hello,
    > > >
    > > > I know if you want to remove the last X characters, you can do it by
    > > >
    > > > =left(A1,(len(A1)-X))
    > > >
    > > >
    > > > I want to remove any characters from a text that is longer than 35
    > > > characters.
    > > > ie, I want to remove characters 36th and onwards.
    > > >
    > > > How can I do it?
    > > >
    > > > Thanks.
    > > > Elaine.
    > > >
    > > >

    >
    >


+ 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