Drop the first 4 digits from a column

[hoganc]

that works great but it hasn't taken away the last / mark E C803/3530 s
it looks like thi

 

[Frank Kabel]

Hi
describe exactly what to create. Do you mean
="E" & MID(A1,5,4)