From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Use custom formulas in data validation to keep out bad data

Use custom formulas in data validation to keep out bad data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use custom formulas in data validation to keep out bad data

“

nine characters, and the leftmost digit cannot be zero. 2 So, let's set up a rule, say for this column right here. 2 We want social security numbers here. 2 Gotta be numeric. 2 Must be nine characters, can't be zero in left number. 2 These functions might be helpful. 2 LEN has to do with length, ISNUMBER allows us 2 to check if an entry is a number. 2 Left allows us to pull data 2 out of the left-hand side of a cell. 2 So if this were a social security entry, 2 here in column N, first order of business, 2 go to Data Validation. 2 Is there anything out here that would jump 2 into our minds right away? 2 How about length, now that's text length, 2 what if we try this, equal to nine. 2 Well that might work. 2 Let's try that. 2 First of all, put in nine numbers. 2 That's fine. 2 Now put in eight numbers, 2 that obviously doesn't work, 2 because it's too short. 2 Well, looking good, let's say, for a bit. 2 Now, I've…

Contents