Re: Limiting text entries

Tech-Archive recommends: Fix windows errors by optimizing your registry

Please disregard my last posts. My spread*** info. starts on row 2 and I
had forgotten to change the cell references to indicate that. Both formulas
appear to be working beautifully, thank you SO much. However, I am getting a
circular reference for both formulas. I am hoping that will not mess with
any results.

Thanks again!

"Joerg Mochikun" wrote:

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.



.

Quantcast