Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The MID() function doesn't worry about missing characters at the end. Thus, if Text is a text expression,

=MID(Text;5;10000) will work for you even if LEN(Text ) is much less than 10000.

=RIGHT(Text;LEN(Text)-4) will work as RIGHT() did in your second piece of code.

The leftmost 4 characters will be deleted.

A third variant:


[PS: In your example I saw a "u" on the 4th position.]