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 cells with ZIP code separated with a space in batch?
Name Date 2013/11/21 Hit 2

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

Country sites

P

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