Hey everyone,

Does anyone know a formula where you can remove all the text before the last forward slash?

For example; entry: Garden/Shed/Table/Ashtray and I would just like Ashtray!

Any help would be greatly appreciated, don't really fancy going through 3500 records manually!

Thanks very much for your time, any help would be greatly appreciated,

Luke