Shortening a Description to 40 characters

[Robert_Conklin]

I have a list of 2,200 spare part descriptions that need to be shortened to 40 characters. Will someone please help with a formula that will do this?

 

[JimM]

This will take the first 40 characters of the description

=LEFT(A1,40)

 

[Robert_Conklin]

Thank you, JimM! That worked beautifully!