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 cell with separated characters of a ZIP code?
Name Date 2013/11/21 Hit 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.
LIST

Country sites

P