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.

Try =left(A1, 35)

<[email protected]> wrote in message
news:[email protected]...
> 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

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

Vaya con Dios,
Chuck, CABGx3



"[email protected]" 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.
>
>

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
>
>
>
> "[email protected]" 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.
> >
> >

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

Vaya con Dios,
Chuck, CABGx3



"[email protected]" 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
> >
> >
> >
> > "[email protected]" 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.
> > >
> > >
>
>