+ Reply to Thread
Results 1 to 3 of 3

Help with Post code format

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    ballymoney n.ireland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Exclamation Help with Post code format

    Hello

    I was wondering if it was possiable to format a cell so that it only shows the letters that i wish for example:
    if my post code was bt53 i only want it to accept "bt" and nothing else, so if i typed in bg53 it wouldnt allow it?
    can this be done?


    Many Thanks
    Aaron

  2. #2
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Akron, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    208

    Re: Help with Post code format

    You only want the cell to accept bt? Not bt53 or bt54 or ????

    Do a search on data validation, that may be what your looking for. It only allows certain values in cells based on lists you supply.

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help with Post code format

    Hi

    this custom validation formula

    =AND(NOT(ISNA(MATCH(LEFT(C2,2),$I$2:$I$4,0))),ISNUMBER(MID(C2,3,10)*1))

    will allow the codes that are defined in a list in I2:I4 as the first characters, and only numbers after that.

    Will that work?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1