how to remove prefix in excel code example Example: excel remove suffix from string =LEFT(A1;LEN(A1)-N) # Where N is the number of char you want to remove