HI There

i have got a problem with inputting text into a cell. I am creating a work
program for my employees and a can not write multiple text.
i.e.

i cannot input "DOOR" it has to go in as "DOR"
Or
"ROOF" has to go in as "ROF"

Employees now making fun of me saying a cannot spell. PLEASE HELP.

Thanks

David