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 0

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

P

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