Forum Discussion
Deano478
3 years agoRegular Visitor
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.
1 Reply
- Ahmedx
Super User
pls try this