Thread: Format Canadian Postal Code on Entry
View Single Post
  #5  
Old 02-06-2007, 06:05 PM
oldchippy's Avatar
oldchippy oldchippy is offline
"Eagle Eyed" Forum Moderator
  
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2007 (Work) and 2007 (Home)
Posts: 6,933
oldchippy is attaining expert status oldchippy is attaining expert status
Here's an alternative if you require a formula, with your data entry in A1, then this in B1

=LEFT(UPPER(A1),3)&" "&RIGHT(UPPER(A1),3)
__________________
oldchippy
-------------


If you are happy with the help you have received, please add to our reputation by clicking the blue scales icon in the blue bar of the post.

Click here >>> Top Excel links for beginners to Experts

Forum Rules >>>Please don't forget to read these
Reply With Quote