How do I remove a fixed character from a column？

[phoebe_90]

For example, I want to remove "Customer" from the column named "Number". Maybe there will be some space between the character and number.

Before:

Number

706420Customer

709382

112102 Customer

665946

987456  Customer

After:

Number

706420

709382

112102

665946

987456

[binuacs · Accepted solution]

@phoebe_90 Use the Replace() function 

Replace([number],"Customer", "")

[Bren_Spill · Accepted solution]

Trim([Number],"Customer")