Search

Printec

CUSTOMER CENTER
Promise to make customers satisfaction
with the best customer service

FAQ

HOME Help Center FAQ
print
faq
Subject How to populate cell with separated characters of a ZIP code?
Name Date 2013/11/21 Hit 2

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.
WRITE LIST

Country sites

P

  • overseas@printec.com / +82-(0)70-4814-8515, Anita Kim
  • COPYRIGHT (C) 2012 Printec Co., Ltd. ALL RIGHTS RESERVED.