# remove characters from a text under a condition

1. ## 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. Try =left(A1, 35)

3. ## Re: remove characters from a text under a condition

<elaine216@gmail.com> wrote in message
> 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. ## 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. ## 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. ## 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.
> > >
> > >

>
>

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

#### 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