Alternative to comma in a reference cell.

=ISERROR(FIND(CHAR(44),A1))


Gord Dibben MS Excel MVP


On Wed, 23 Jan 2008 10:52:01 -0800, ShaneDevenshire
wrote:

Hi again,

If you want to apply this to the entire sheet, move to another sheet and
enter a comma in a cell. Then name the cell. In my example I named the cell
comma. Now move back to the sheet you want to restrict. Select the entire
sheet and enter the following formula in the Data Validation, Custom:

=ISERROR(FIND(Comma,A1))