ExcelBanter - Formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help (https://www.excelbanter.com/excel-discussion-misc-queries/237863-formula-help.html)

tom

Formula help

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 )

bapeltzer

Formula help

=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 )

All times are GMT +1. The time now is 04:51 PM.