Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i have a long column, where my inputs going to be 1 to 20 (manual)
but in the same cell I would like them to change to certain text as I type for example, if I type 1 and press enter, it should change to the word "John" i.e, 1 John 2 Ron 3 Rob 4 Ross 5 Prince etc. |