Return text

  • Thread starter Thread starter k.roberts
  • Start date Start date
K

k.roberts

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can UDF return a customized hyperlink? 3
Remove e-mail address from general text field. 2
Vlookup with part of cell text 3
Multiple arguments 1
Vlookup and return sheet name also 2
Delete rows based on contents of Col A 0
Search / Find Function 5
Why do Excel functions return the text and not run? 1

Back
Top