Custom List and autofill text

%3CLINGO-SUB%20id%3D%22lingo-sub-1703436%22%20slang%3D%22en-US%22%3ECustom%20List%20and%20autofill%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1703436%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%20I%20am%20using%20Excel%20365.%20I%20have%20a%20column%20with%202%20characters%2C%20example%20A1.%20I%20would%20like%20to%20type%20A1%20in%20the%20cell%20and%20once%20I%20hit%20enter%20have%20Excel%20convert%20it%20to%20Analyst%20Call.%20I%20did%20this%20years%20ago%20using%20custom%20lists%20but%20my%20memory%20is%20failing%20me.%20Can%20someone%20help%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1703436%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1704754%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20List%20and%20autofill%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1704754%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F805823%22%20target%3D%22_blank%22%3E%40AMD11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20mean%20AutoCorrect%20options%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20648px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221596i279FCBFA3E4A6913%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello - I am using Excel 365. I have a column with 2 characters, example A1. I would like to type A1 in the cell and once I hit enter have Excel convert it to Analyst Call. I did this years ago using custom lists but my memory is failing me. Can someone help? Thanks.

1 Reply
Highlighted

@AMD11 

Perhaps you mean AutoCorrect options

image.png