How to populate cell with separated characters of a ZIP code?
作者
发布日期
2013/11/21
点击量
35
For example, if you want to change 123-456 to 1 2 3 - 4 5 6, Assumed that A2 cell has the original ZIP code, 1: ZIP code digit and 1:charater. Enter "=MID(A2,1,1)&" "&MID(A2,2,1)&" "&MID(A2,3,1)&" - "&MID(A2,5,1)&" "&MID(A2,6,1)&" "&MID(A2,7,1)" in B2 cell
When finished, press enter key to check the value of B2 cell, click and drag downward with holding the solid small box of the bottom right.
