How can I split 15 digit numeric number??

[#1]

How can I split 15 digit numeric number??

eg.234879345798375

I want '457' from this number.It is available after 7th digit in number.(required '3' digit after 7th digit)

[tresB · Accepted solution]

use : mid('yourstring',8, 3 ) .

Thanks.

[Gysbert_Wassenaar]

num#(mid(234879345798375,8,3))

[#4]

use this

mid('abcdef',3, 2 ) returns 'cd'.

or

=mid('234879345798375',8,3)

[peschu123]

Hi Gysbert,

can you tell me the difference of "num" and "num#". I can't see any difference when I compare the 2 commands in Help.

Sorry for talking OT.

Regards,

Peter