Updating a formula to miss first four characters of a FIND

  • Thread starter Thread starter Curtis Fray
  • Start date Start date
C

Curtis Fray

Hi,

I was very helpfully provided with the below formula yesterday to help me
filter information (thanks to JE McGimpsey):

=LEFT(MID(A1, FIND("SMTP:", A1), 255), FIND("%", MID(A1, FIND("SMTP:", A1),
255))-1)

Could someone tell me how to update this so in addition to what it's already
doing, it doesn't display the "SMTP:" in the helper column?

Thanks,

Curtis.

====================================
When replying by email please remove the X
====================================
 
Hi,

I was very helpfully provided with the below formula yesterday to help me
filter information (thanks to JE McGimpsey):

=LEFT(MID(A1, FIND("SMTP:", A1), 255), FIND("%", MID(A1, FIND("SMTP:", A1),
255))-1)

Could someone tell me how to update this so in addition to what it's already
doing, it doesn't display the "SMTP:" in the helper column?

Thanks,

Curtis.
Click to expand...

You'd probably get a more coherent response if you were to keep your question
in the same thread, so we could see the background. But one way (perhaps not
the best):

=LEFT(MID(A1, FIND("SMTP:", A1)+5, 255), FIND("%", MID(A1, FIND("SMTP:",
A1)+5,255))-1)

--ron
 
That's done it. Thanks Ron.

Curtis.

Ron Rosenfeld said:
You'd probably get a more coherent response if you were to keep your
question
in the same thread, so we could see the background. But one way (perhaps
not
the best):

=LEFT(MID(A1, FIND("SMTP:", A1)+5, 255), FIND("%", MID(A1, FIND("SMTP:",
A1)+5,255))-1)

--ron
Click to expand...
 
That's done it. Thanks Ron.

Curtis.
Click to expand...

You're welcome. By the way, if there is a space after the SMTP: that you also
want to eliminate, change the +5's to +6's.


--ron
 
Back
Top