Re: Limiting text entries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

As a start for column 1:

For A1 apply the custom validation formula
=MID(A1,LEN(A1)-1,1)=","

This will allow only entries where the second from last character is a
comma.
You can use the AND function to combine more criteria in your formula and
make it as sophisticated as you like.

Joerg



"Help4me" <Help4me@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7D1CB948-00AD-48A3-9BCA-CDFDC9B2D940@xxxxxxxxxxxxxxxx
I have two columns in which I would like to limit the way text is input:

1) Lastname,First initial with no spaces (i.e., Smith,R)
2) One capital letter followed by five digits (i.e., D12345)

I do not have any ideas for column 1.

I can use the Limited Text validation feature for column 2, but that only
limits the number of characters, not the type of characters input.

Thank you so much.


.

Relevant Pages

  • Re: Limiting text entries
    ... My spreadsheet info. starts on row 2 and I ... had forgotten to change the cell references to indicate that. ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
    (microsoft.public.excel.misc)
  • Re: Limiting text entries
    ... Four statements in the AND function, separated by commas check if ... otherwise Excel regards it as text) ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
    (microsoft.public.excel.misc)
  • Re: Limiting text entries
    ... Four statements in the AND function, separated by commas check if ... otherwise Excel regards it as text) ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
    (microsoft.public.excel.misc)
  • call a VBA function for data validation?
    ... I'm trying use Excel's Data Validation with a custom validation formula, ... but the formula length is limited to 255 characters. ... In order to use a longer formula, ...
    (microsoft.public.excel.programming)
  • Re: Periodic Table
    ... hardly notice these bugs, but if the situation were reversed and I ... had to switch from period to comma for certain things to work, ... characters except NUL, ... Actually, with MS Windows 98SE, you can use a comma in a file ...
    (comp.sys.hp48)