Showing posts with label Yahoo. Show all posts
Showing posts with label Yahoo. Show all posts

Saturday, May 1, 2021

How to extract Gmail, Yahoo, Hotmail, Live etc. in excel:

 (Suppose you applied the following formula in D column)

=RIGHT(A2,LEN(A2)-SEARCH("@",A2))

Now to the next of D column you can write following formula to separate specific ESP

=if(d2=”gmail.com”,”Gmail”,if(d2=”live.com”,”Live”,if(d2=”hotmail.com”,”Hotmail”,if(d2=”yahoo.com”,”Yahoo”,if(d2=”aol”,”Aol”)))))


How to merge a branch to main branch in Github.

In Terminal or Command Prompt:  git checkout main  [switch to main branch] git pull origin main  [grab latest updates from main branch] git ...