Function to indicate the amount of characters in a cell?

G

Guest

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
 
G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
calculation based on the range you indicate in another cell 2
Autocopy the first cell with more than 30 characters to a different sheet? 1
Formula/Function for Counting Characters in a cell 4
Text wrap spec 4
Limiting The Amount of Text 3
Comparing characters in cells 7
How can I display and print more than 1024 characters in a cell? 1

Top