Results 1 to 4 of 4

Thread: Restrict cell entry of B1 as per the value in A1

  1. #1

    Restrict cell entry of B1 as per the value in A1



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to restrict value in cell B1 to Alphabets (and no numbers) if cell A1 value starts with "RA1". Could you please advise on the formula for this ?

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Try
    Code:
    =IF(LEFT(A1;3)="RA1",TRUE,FALSE)
    or
    Code:
    =IF(LEFT(A1;2)="RA",TRUE,FALSE)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    sorry on error of formula (separator is wrong)

    Code:
    =IF(LEFT(A1,3)="RA1",TRUE,FALSE)
    or
    Code:
    =IF(LEFT(A1,2)="RA",TRUE,FALSE)
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  4. #4
    Thanks Navic. Per the formula i am getting only true and false in B2 against i want to restrict numbers and only allow alphabets.

Posting Permissions

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