Excel formula if cell contains any text then return value

Excel formula if cell contains any text then return value pictures 5