how to divide a long number into two and put them into two different column of excel

[johnmnp]

I need divide a long string number like:"12345678" into two "1234" &"5678" ,which can be disply in the two different waveform and write them into the same two different column at same time ,may I knidly know how should I do it?Thanks

[johnmnp]

the following is the attacheed example

[GerdW]

Hi John,

when it's a string then use "Split string"...

When it's a number you may use quotient&remainder.