Most valuable professional
  • Hot Topics

Excel Data Validation Must Contains mark ' (approstrops) in Left

hi all, i need your help how create data validation with criteria : - start mark ' (approstrops) in left position like example this below : '6136716 '981289 '2091234 etc... i have using formula =LEFT(B3)="'", but still not working... any help me, thanks in advance... m.susanto

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel