Mass remove numbers

[SamCunneyworth]

Hi,

I work in a school and as part of Safeguarding, all of our Sixth Form/Post-16 students have ID Cards with scannable barcodes on them which are unique to their Admission No on SIMS.net. I've ran a report, and exported these values to Excel, no problems. My issue is, the admission no's are expressed in XXXXXX but we only need XXXX, due to the system our in-house developer created. ALL of the values have 00 in front of the 4 values we actually need (For example, 006454)

Whilst I could go through and delete the 0's one field at a time, there are well over 150 students and this would take an age. Is there a quick way of doing this?

Thanks in advance
Sam

[63falcondude]

Try =RIGHT(A1,4) or use find & replace to find 00 and replace with nothing (blank).