Search

Printec

FREE SOFTWARE
Free software doownload service

Software FAQ

HOME Software Software FAQ
print
This is Printec Software FAQ board

There are frequently-asked questions and answer for each matter.
If there in no answer for you questions, please leave the question
on the lnquiries board.

Inquiries

Search
faq
Subject How to populate cells with ZIP code separated with a space in batch?
Name Date 2013/11/21 Hit 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.

P