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
Nick