View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jg jg is offline
external usenet poster
 
Posts: 42
Default Formatting Cells for Quick Input of Data

I need to enter over 200 serial numbers into Excel.

They all start with the same 6 characters and all end in the same 3 like so:
E33213**0P5

Can I format the cells so that I only have to input the 2 middle characters
and Excel will auto fill the other information?

The 2 characters I need to enter are letters, not numbers.

I tried the following without any luck:
E33213??0P5
E33213##0P5