Email issue

[Dendy]

(e-mail address removed) Hand

The above is an ex.

Information is all in one cell. Need to get ride of everything past SMTP
Thanks

 

[Dave Peterson]

You want to keep SMTP??

Select the range
edit|replace
what: SMTP*
with: SMTP
replace all

If you want to get rid of SMTP, too:
Select the range
edit|replace
what: SMTP*
with: (leave blank)
replace all

 

[Dendy]

Works great Thank You

You want to keep SMTP??

Select the range
edit|replace
what: SMTP*
with: SMTP
replace all

If you want to get rid of SMTP, too:
Select the range
edit|replace
what: SMTP*
with: (leave blank)
replace all