Hi Folks,
This week we are exploring how do we use the "Data Validation" feature in excel to validate names. The scenario what we are expecting here is system should allow to enter the names in the "LAST NAME, FIRST NAME" format. Precisely we are making sure the comma is entered while entering the names.
Check out the attached file available where i have illustrated the process of achieving it.
This week we are exploring how do we use the "Data Validation" feature in excel to validate names. The scenario what we are expecting here is system should allow to enter the names in the "LAST NAME, FIRST NAME" format. Precisely we are making sure the comma is entered while entering the names.
Check out the attached file available where i have illustrated the process of achieving it.
1 Attachment(s) [Login To View]