Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel validate (2002)

    how do you make sure that a cell contains .com as the last 3 characters

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: excel validate (2002)

    Welcome to Woody's Lounge!

    ".com" is 4 characters, not 3.

    Select the cell (or cells).
    In the following, I assume that the cell (or the first cell in the selection) is A1.
    Select Data | Validation...
    Activate the Settings tab (if necessary)
    In the Allow dropdown, select Custom.
    In the Formula box, enter

    =RIGHT(A1,4)=".COM"

    If you don't want to allow the user to clear the cell once it has been filled, clear the "Ignore Blank" check box.
    Activate the Input Message tab.
    Enter a helpful message that will be displayed when the user selects the cell.
    Activate the Error Alert tab.
    Make sure that the Stop style is selected.
    Enter a warning message that will be displayed if the user enters an incorrect value.
    Click OK.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel validate (2002)

    On a similar subject, is there any way of selecting a different list for validation, based on the value of another cell?
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: excel validate (2002)

    See the thread starting at <post#=463944>post 463944</post#>.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2004
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel validate (2002)

    Hans (whichever clone it is that answered this one...!), as ever, you're a lifesaver!
    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    <font color=448800><font face="Comic Sans MS"><big>Lyra J </font color=448800></font face=comic></big>
    <img src=/S/flags/UK.gif border=0 alt=UK width=30 height=18> Ducking the arrows in Robin Hood country <IMG SRC=http://www.wopr.com/w3tuserpics/Lyra_J_sig.gif ALT="No, Admins, no! I'm sorry, okay!" title="No, Admins, no! I'm sorry, okay!">

  6. #6
    New Lounger
    Join Date
    Apr 2005
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel validate (2002)

    Hans

    Thank you for this help this worked as explained.

Posting Permissions

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