I have a column called Machine #. It is a Single line of text. I would like it to be in this format:

  • Mxxxxx - all the 'x digits' are numerical.
  • The first item should be called M00001.
  • I would like each item to contain 6 characters.

I've tried using =LEN(Machine #)=6, but I get an error message:

enter image description here

I'm not sure where I'm going wrong. Could it be that the column name is causing the problem, since it contains a # ? I created a test column without any special symbols and this enforced the 6 character column validation.

However, in another question the $ symbol is used in the column name and the column validation seems to accept the $ symbol!

Column validation pic

  • 1
    Create the column with only name "Machine" and change the display name to "Machine #" then after. validation will work after changing the display name too. Commented Jul 17, 2018 at 9:46
  • remove your repeated question Commented Jul 17, 2018 at 9:52
  • 1
    I think you need to wrap a column name with a space with [], so =LEN([Machine #])=6.
    – moe
    Commented Jul 17, 2018 at 10:21


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.