Updating a formula to miss first four characters of a FIND

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

 

[Ron Rosenfeld]

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.

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

 

[Curtis Fray]

That's done it. Thanks Ron.

Curtis.

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

 

[Ron Rosenfeld]

That's done it. Thanks Ron.

Curtis.

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