Search()

[TimE]

I am currently using search() to return everything to the left of "-", but am having trouble getting it to work to retrieve everything to the right of "-". Any thoughts?

Please Login or Register  to view this content.

Thanks in Advance,
TimE

[BigBas]

Try this and let me know if it works:

=IF(LEN(M2)=0,"",IF(COUNTIF(M2,"*-*")>0,RIGHT(M2,LEN(M2)-SEARCH("-",M2,1)),M2))

[TimE]

Thank you for pointing out the obvious. Don't know why I made it harder than it was.

Thanks