format cell to always insert specific thing, when a specific name is typed???

Is there a way to format cells to where – when you type in a certain person’s first name, it will insert something entirely different?

This has seemed to have happened on a computer at work. In Excel, when I type in “Martha” …
then tab, or otherwise leave that cell, Martha changes to “•Cool”

If I type in anyone elses name – it stays that name. But if I type in “Martha”….. it changes to “•Cool” … with the bullet and the word Cool.

I think someone (Martha) is messing with me – lol. They probably know a “secret” format to do this. I am trying to figure it out without having to actually ask Matha.

Hope you can help!

Within the same cell, not that I know of - if you enter text into the cell, it overwrites what would have been in the cell before; however, you can enter this formula into an adjacent column (see attached example):
=IF(A2="Martha","•Cool",A2)
and copy that down.
If you type names in Column A, it will then copy the name as it appears in Column A into the adjacent cell in Column B except for where you have typed Martha's name, in which case it will enter "•Cool"

Well somehow it was done .... I tried almost every cell individually and if I typed Martha and tabbed to the next cell, OR if I clicked on any other cell, Martha changed to •Cool.

Someone else suggested that a VBA code might have been used. I have no idea what a VBA code is. Has something to do with Macros...?

VBA = Visual Basic for Applications (a sort of code that you write that specifies formulas, functions, etc to apply to a set of data)
That probably is how it was done since typing text over a formula in a cell overwrites it, but I am not good at macros or vba, sorry.

Ok ~ I will try this next time I am at work .... which will be Monday 4/8/13, and let you know.
Thanks!

I figured it out. It was done in Autocorrect.

When you type "Martha", autocorrect to "•Cool"

Thanks for trying to help!