Excelワザ_名前の間にスペースを入れる

余分なスペースは
Trim関数で取れるけど
「井上」を「井 上」のように
一文字ずつスペースを入れる場合は……
T先生、これでどうでしょう?

b0186959_20353786.png


セルA2に名前
セルB2に式
=CONCATENATE(MID(A2,1,1)," ",MID(A2,2,1)," ",MID(A2,3,1)," ",
MID(A2,4,1)," ",MID(A2,5,1)," ",MID(A2,6,1)," ",MID(A2,7,1)," ",
MID(A2,8,1)," ",MID(A2,9,1)," ",MID(A2,10,1)," ")

苗字がとりあえず4文字の人まで実験完了。
[PR]
by school-pc | 2015-02-20 20:37 | Comments(0)