Regular Expression to limit text length in Open Office Calc

181 views Asked by At

What is a regular expression compatible with OpenOffice Calc to limit each cell to 30 characters?

Example:

This is a sample text for my website.

Becomes:

This is a sample text for my w

1

There are 1 answers

0
Jim K On BEST ANSWER

If the text is in cell A1:

=LEFT(A1,30)

Documentation is at https://help.libreoffice.org/Calc/Text_Functions#LEFT.