Another option:

=REPLACE(REPLACE(A1,LEN(A1)-4,,"."),1,5,"")

If those prefix characters to be removed are always 5 characters.

Nadia wrote:

I have thousands of payroll records that are imported into excel on a daily
basis.
The cost codes appear like this: 7002/1045.824240305
The 7002/ needs to be removed and a . (dot) inserted five from the end
like this: 1045.8242.40305
Please note there are hundreds of different cost codes so I cannot simply
copy and paste but they must all be coverted so the format is the same.
I am desperate for suggestions.
cheers,
Nadia

--

Dave Peterson