Results 1 to 3 of 3

Function to valid a column start with "http"

Threaded View

jonat2 Function to valid a column... 05-02-2008, 02:51 PM
NBVC The validation doesn't work... 05-02-2008, 03:24 PM
jonat2 It's working! Thank you... 05-02-2008, 03:48 PM
  1. #1
    Registered User
    Join Date
    05-02-2008
    Posts
    3

    Function to valid a column start with "http"

    Hi,

    I'm looking for a way to validate if the input start with "http".

    I have a formula in my validation field that look like this:

    =(MINUSCULE(GAUCHE(B2;4))="http")
    It's okay for the cell B2... but I need that validation to apply on all the colum. I tried:

    =(MINUSCULE(GAUCHE(B:B;4))="http")
    But I keep getting an error EVERY time, even if it's valid.

    Thanks.

    jonat

    Edit: As you can see my excel is'nt in english... in english, "minuscule" should be something like "lowercase" and "gauche" mean "left"
    Last edited by jonat2; 05-02-2008 at 02:59 PM.

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