Hi, Max, Alojz and Shane,

Thanks a lot for all of you guys help. I've got some concept now, but I
don't really understand start from he

"Freeze cols B to F with an "in-place" copy n paste special as value. Insert
a
new col C, then select col B, click Data Text to Columns, delimited, enter
a period for "Other" in step 2. Click Finish. And that should return the
exact results that you seek in cols B to G."


Sorry for I'm too stupid, but please kindly explain more clearly, thanks a
lot.