Extract the Url and name from emails in Excel
Using the search function. Using the Left function. Using the Len function.
=”www.”&(RIGHT(B6,(LEN(B6)-(SEARCH(“@”, B6)))))
=LEFT(B6,(SEARCH(“@”,B6)-1))
For more help visit my website
I am able to provide online help on your computer for a reasonable rate.
MY videos are all created on Camtasia.
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Great !
how to find websites from company names ??