This project has moved. For the latest updates, please go here.

LEFT function has different behaviour from MS Excel

Sep 17, 2014 at 10:14 AM
The LEFT function will fail if the cell content is shorter than the formula. Example: =LEFT(V3,20) will fail if the text length in V3 is less than 20.

This style is fully acceptable in MS Excel and it would be very helpful if the functions had the exact same behaviour as MS Excel if possible.
Great work by the way :)
Sep 17, 2014 at 4:30 PM
This has already been fixed. Pick up the latest version.
Marked as answer by Havardo on 9/18/2014 at 1:11 AM