| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
