+ Reply to Thread
Results 1 to 6 of 6

Restrict data entry in a cell to a capital X

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Restrict data entry in a cell to a capital X

    Can someone help me write a formula that will restrict the entry into one cell to only a capital "X" in the Data Validation Custom window?

    The restriction will be ONE character and UPPER case.

    =exact

    Also, can the formula be written (without VBA) that will change a lower case x to an UPPER case X?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Restrict data entry in a cell to a capital X

    =EXACT(A1,"X")
    where A1 is the cell you are applying the validation to. You cannot use a formula to change the entry in the same cell that it is entered into.
    Rory

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Restrict data entry in a cell to a capital X

    thank you!

  4. #4
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Restrict data entry in a cell to a capital X

    Follow-up question, what if I want to add an option for a lower case "x"

    =EXACT(A1,"X") and add:

    or"x"

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Restrict data entry in a cell to a capital X

    Just =A1="X" since that will not be case-sensitive, unlike the EXACT function.

  6. #6
    Forum Contributor
    Join Date
    05-01-2013
    Location
    Richmond, VA
    MS-Off Ver
    Excel 365
    Posts
    164

    Re: Restrict data entry in a cell to a capital X

    Thank you again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Wanting to restrict data entry to cells if another cell is blank.
    By trimmellr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2021, 12:35 AM
  2. Replies: 3
    Last Post: 03-30-2019, 12:48 PM
  3. restrict data entry basing on adjacent cell value
    By tkraju in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 01:45 PM
  4. Restrict data entry if preceeding cell value is greater than or blank
    By GreggTO in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2013, 11:46 AM
  5. Replies: 2
    Last Post: 03-12-2013, 03:27 AM
  6. Restrict data entry based on another cell
    By northbank in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2012, 11:33 AM
  7. NEED HELP - How to disable a cell to restrict data entry
    By Sriram in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2006, 10:50 AM

Tags for this Thread

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