Try...

=LEFT(A1,FIND(",",A1)-1)

Hope this helps!

In article .com,
" wrote:

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.