How to excel in different digital replacement for the space

In the same column in the Chinese figures and Zhang
080101 as
080102 Liu
080103 Lee
……
figure is based on the order.How will these different figures for the replacement of space? Because Many, too cumbersome manual.
Replaced by the hope that the
Zhang
Liu Li
……
Thank you

also every time such a problem that is very simple ah.pressing the Ctrl + H, first of all replace the 1.2.3.4.5.6.7.8.9.0 order to replace it.If too much space, And then you put six spaces replaced by a space.Ctrl + F, choose to replace, respectively, by 0-9 to replace the air, nothing is imported by the formula
= REPLACE (cell reference, 1,6 , “”), Press Ctrl + H, first of all replace the 0 to 9, followed by the replacement of 1,2,3,4,5,6,7,8.And then 9 and then replace the space on the line, you try it you approach Will do, I suggest that the use right (a1, 1) to get
or breakdown:data, points out, fixed width.6 F of positive solutions