thanks that works great, however the return does not seem to be a number
if the answer is 123 I cannot then use it in a formula

If I have "123456789" in a cell I wish to copy specifc parts of it to other
cells
i.e.
A1 first 3 - 123
A2 second 3 - 456
A3 third 3 - 789
How can I do this both in a worksheet and using VBA.
Thanks
Jo