Function to indicate the amount of characters in a cell?

Trying to do a conversion of data into a flat file. Using excel we have a
column called Project Description.

I want to run a function to ensure that the project descrption in each cell
does not exceed 70 characters.

Is there a function that I can use for this?

For example

A project for all to review

This title has 28 characters (counting from A to w), other than manual not
sure if this can be done

Thanks

Try this:

This function returns the number of characters in Cell A1
=LEN(A1)

This function returns up to 70 characters from cell A1
=LEFT(A1,70)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"ssciarrino" wrote:

> Trying to do a conversion of data into a flat file. Using excel we have a
> column called Project Description.
>
> I want to run a function to ensure that the project descrption in each cell
> does not exceed 70 characters.
>
> Is there a function that I can use for this?
>
> For example
>
> A project for all to review
>
> This title has 28 characters (counting from A to w), other than manual not
> sure if this can be done
>
> Thanks

Perfect Ron! Thanks!

"Ron Coderre" wrote:

> Try this:
>
> This function returns the number of characters in Cell A1
> =LEN(A1)
>
> This function returns up to 70 characters from cell A1
> =LEFT(A1,70)
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "ssciarrino" wrote:
>
> > Trying to do a conversion of data into a flat file. Using excel we have a
> > column called Project Description.
> >
> > I want to run a function to ensure that the project descrption in each cell
> > does not exceed 70 characters.
> >
> > Is there a function that I can use for this?
> >
> > For example
> >
> > A project for all to review
> >
> > This title has 28 characters (counting from A to w), other than manual not
> > sure if this can be done
> >
> > Thanks