How to separate email id addresses to username and domain in excel
How to separate email id addresses to username and domain in excel
Here we are learn how to separate email id addresses to username and domain in excel.
I have a data which is an email id. ID is to be separated from this email Id and sites to be separated.
Where @ in Email ID, To separate from left and separate from right.
If we do it in a simple way, we can only use this email ID.
How to use Left Formula in excel:-
From the LEFT FORMULA we apply the normal formula and pick up 4 characters from the left.
=LEFT(B5,4)
Answer :- arun
How to use Find Formula Function in excel:-
We put the FIND FORMULA here and figure out @ which position.
Let us know how the formula of the find works
FIND FORMULA helps to tell that whatever position we want to search, it is at which position in that text.
Here we want to search @ at which position, So now we come to the formula, look carefully
=FIND("@",B5,1)
Answer :- 5
Our answer is 5, that means @ is at number 5 position
Now we edited the same formula which was applied above and made it dependent, that means linked the formula of find with the LEFT FORMULA.
=LEFT(B5,E5-1)
Answer :- arun
Now if we have any e-mail that has @ anywhere, it will separate the text on the LEFT.
How to use RIGHT with LEN Formula in excel:-
we apply RIGHT FORMULA,
Here Now we have to find out how many characters to be pick right side,
You can find the length of the text by applying the LEN FORMULA.
From the length of the total text, the length before @ will be subtracted
Now we will have the right side data
=RIGHT(B5,LEN(B5)-E5)
Answer :- gmail.com
Now we will have the right side data
Now you have learned that you can separate the left and right side data.
RIGHT LEN FIND Formula in excel:-
Now we can apply this formula with the Find formula
=RIGHT(B5,LEN(B5)-FIND("@",B5,1))
Answer :- gmail.com
The answer will come same, we had earlier considered the value of the find formula as the base and now we are applying the direct formula.
We learn easily How to separate email id addresses to username and domain in excel.
No comments:
Post a Comment