Replace Part of a String with Blank

[Tommy_Alterax]

Hi Guys,

I have a set of data attached- Look at the variable "Level"

I would like to replace the first part of the string "20-120" with a blank (not text to columns if possible) - Is Regex ?

Secondly where there is a "PIR" replace this with a blank also - pleae note not all rows have a PIR

Regards,

             Tommy

[kelsey_kincaid · Accepted solution]

Hi @Tommy_Alterax ,

Will there ever be values besides 20-120 and PIR that you want to replace with blank in your string? If not, you could create a formula with a nested REPLACE formula to replace those two values in your string.

TRIM(
REPLACE(
REPLACE([Level],'20-120 ',''),'PIR',''))

[Tommy_Alterax]

Thanks I think that works !