I want a range of cells to automatically start with "E" and then I enter
other characters in the specific cells.

I also want a range of cells to automatically start with "10" and then enter
other numbers in the specific cells.

I know how to do that in Access but not in Excel.

Many thanks, in advance, for your help.