Dynamic removing data

[k3pineapple]

Hi all,

I am trying to remove the specific data in the each cell. not sure which function i should use here. thx

Input

Company	User	Product	Sector Name
ABC	Amy	Apple	Sector 1
ABC	Amy	Apple	Sector 2
ABC	Cindy	Banana	Sector 3
ABC	Dave	Cherry	Sector 4
DEF	Eason	Apple	Sector 1
DEF	Frank	Banana	Sector 2

Output

Company	User	Product	Sector Name
ABC	Amy	Apple	1
ABC	Amy	Apple	2
ABC	Cindy	Banana	3
ABC	Dave	Cherry	4
DEF	Eason	Apple	1
DEF	Frank	Banana	2

Many thx

[sparksun · Accepted solution]

Use the following formula:

Replace([Sector Name],"Sector ","")

[k3pineapple]

appreciated