Regular Expression to limit text length in Open Office Calc

Question

173 views Asked by GingerGirl At 02 January 2017 at 19:55

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

There are 1 answers

**Jim K** · Accepted Answer · 2017-01-02 23:36:54

Jim K On 02 January 2017 at 23:36 BEST ANSWER

If the text is in cell A1:

=LEFT(A1,30)