=LEFT(A1,FIND("SMTP",A1)+3)
"tom" wrote:
In Excel 2007 I would like help writing a formula to remove text everything
right of the SMTP (see below). All of this infomation is in cell A1 so it
should be an easy formula, but I don't know how to right it.
TFTH,
Tom
MTPBrandon Chase )