I use that frequently for other purposes but it is not an option here. I was hoping to do it with a single formula. I know I can use LEN to select, say the first 10 characters, in the name but I'd like something that stops at the comma. I suspect there is a way to do it with LEN and SEARCH but I can't figure it out.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.