|For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like.|
Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting from the left:
If the part you want to strip off might contain something other than 3 characters, then we need to find the 2nd dot in the string and remove it and everything after it. This formula should work regardless of how many characters follow the 2nd dot.
For your second question, your text doesn't match your screen capture, so I don't really know what you are looking for.
Your text says "I want only "ME" email ids only" but your screen capture shows firstname.lastname@example.org in the same column as the "me" emails.
What exactly are you looking for?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.