if you were to write

'cat_race'

in a cell in excel then when you press enter it will show as

cat_race'

to get it to show the ' on both sides you would have to write

''cat_race'

or

="'cat_race'"

why?