Drop the first 4 digits from a column

hoganc · Oct 5, 2004

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

Frank Kabel · Oct 5, 2004

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