Forum Discussion

Deano478's avatar
Deano478
Regular Visitor
3 years ago

Removing prefixes containing a -

Hi everyone,

 

This is my first post on here and I hope I do this correctly. So im currently hitting a brick wall with something that may sound simple to experienced users.

 

But I have data like so:

PT - No Start
CbCr - In Progress
CT - No Start
PT2 - To be determined 

and so on and what Im trying to do is essentially remove all those prefixes that contain the - so I can get an output in my column like so:

 

No Start

In Progress

No Start

To be determined

 

Many thanks in advance.