Convert shorthand to longhand

Occasional Visitor

Is it possible to type a single letter into a cell but it populates it with the actual word instead of having to write it in full? I.E. type 'C' but it populates it with 'Ceiling'

 

Thanks

1 Reply

@Jedwards1320 You might use AutoCorrect, but that would affect all Office applications, so it's probably not desirable.

You might use VBA instead. See the attached sample workbook.

To view the code, right-click the sheet tab of Sheet2 and select 'View Code' from the context menu.