Truncating? A Text String

  • Hi I need to truncate (I think) a cell that could look like the following

    CR12345 - Name of the CR
    12345 - Name of the CR

    All I need from this is the CR/12345 piece of text and not the whole name, I could use the left(name,7) but this will only work if all people enter it in the same way.

    As always any help is greatly appreciated


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!