How to populate cells with ZIP code separated with a space in batch?
作者
发布日期
2013/11/21
点击量
42
For example, if you want to change 123-456 to 1 2 3 - 4 5 6, Assuming that A2 cell has the original ZIP code, enter '=TEXT(A2,"# # # - # # #")' 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.
