Function to indicate the amount of characters in a cell?

S

ssciarrino

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
 
R

Ron Coderre

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
 
S

ssciarrino

Perfect Ron! Thanks!

Ron Coderre said:
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
Click to expand...
 
Top