Further Help

[Simon]

Thanks for the help but I forgot to add in something.

this formula '=left(A1,2)&right(A1,2)' pulled back 'AC58'
in cell 'B2' from 'AC1003258' from cell 'A1'.

I now need to have the middle numbers in cell 'C1'. so
the answer would be '10032'.

Can anyone help???

 

[garfield-n-odie]

=mid(a1,3,5)