<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - NEW FORMAT:Some characters with the any symbol" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129613#c1">Comment # 1</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - NEW FORMAT:Some characters with the any symbol" href="https://bugs.documentfoundation.org/show_bug.cgi?id=129613">bug 129613</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>Your input of BC1123DIR190X is of type Text, hence only the @ format code is applicable. This could work with prefix or suffix literal text like "prefix "@ or @" suffix" but nothing else, no interspersed "display masks" (or whatever one would call that). You could use the REGEX() function to transform cell content like =REGEX("BC1123DIR190X";"(.{6})(..)(.)(\d+)(.*)";"$1-$2-$3-$4-$5") to "BC1123-DI-R-190-X", or any other exact match.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>