Function to indicate the amount of characters in a cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ssciarrino - 27 Mar 2006 15:42 GMT

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

Reply to this Message

Ron Coderre - 27 Mar 2006 15:51 GMT

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

> Trying to do a conversion of data into a flat file. Using excel we have a
> column called Project Description.
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

ssciarrino - 27 Mar 2006 16:03 GMT

Perfect Ron! Thanks!

> Try this:
>
[quoted text clipped - 28 lines]
> >
> > Thanks

Reply to this Message