Hi, I need to return text from a cell which contains e.g. Our Lady of
The Convent School, Liverpool. I need to return all text before the
",". I know there is a way to do it using LEFT, LEN functions but
can't get it to work.