| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| input data dependent on other cells | Excel Worksheet Functions | |||
| is there a quick easy way to input time? | Excel Worksheet Functions | |||
| specify a range of cells for data input, down then over | Excel Discussion (Misc queries) | |||
| Data input in cells | Excel Discussion (Misc queries) | |||
| Is there a quick shortcut to swap the data in two cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
