Description: for ex: INPUT to cell, BC1123DIR190X ->FORMATTED BC1123-DI-R-190-X or ->FORMATTED BC112:3DIR:R19:0X I would be very glad if I could make something like phone number formatting 0000-000-0000. Why is it need: for product code, for members ID, etc Steps to Reproduce: I would be very glad if I could make something like phone number formatting 0000-000-0000. Actual Results: for ex: INPUT to cell, BC1123DIR190X ->FORMATTED BC1123-DI-R-190-X or ->FORMATTED BC112:3DIR:R19:0X Expected Results: Why is it need: for product code, for members ID, etc Reproducible: Always User Profile Reset: No Additional Info:
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.
No reply in 2 months, so I guess reporter is happy with Eike's advice