Help Please . extracting data

[shaunkaz]

I have text in column F, which is brought through on a report, what I need in column I is the last word.. example shown below

Thanks

Column F	Column I
Other-06/Start UP/Shut Down	Shut Down
Other-04/Block Back	Block Back
Maintenance-03/Stacker	Stacker

 

[AlanY]

try this in I2 and copy down

=TRIM(RIGHT(SUBSTITUTE(F1,"/",REPT(" ",500)),500))

 

[shaunkaz]

try this in I2 and copy down

=TRIM(RIGHT(SUBSTITUTE(F1,"/",REPT(" ",500)),500))

Brilliant.. Thankyou very much

 

[sandy666]

with Power Query

raw	TAD
Other-06/Start UP/Shut Down	Shut Down
Other-04/Block Back	Block Back
Maintenance-03/Stacker	Stacker

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    TAD = Table.AddColumn(Source, "TAD", each Text.AfterDelimiter([raw], "/", {0, RelativePosition.FromEnd}), type text)
in
    TAD

 

[AlanY]

Brilliant.. Thankyou very much

you're welcome