Forum Discussion
Solved
fomula to use
the second column looks like
=MID(A1, SEARCH("@",A1)-1, LEN(A1)-(SEARCH("@",A1)-1) )
or with Excel 365
=LET(in,A1:A100, at, SEARCH("@",in)-1, MID(in, at, LEN(in)-at)
and third column
=LEFT(A1,SEARCH("@",A1)-1)
6 Replies
And your question is?
- can you help me
the second column looks like
=MID(A1, SEARCH("@",A1)-1, LEN(A1)-(SEARCH("@",A1)-1) )
or with Excel 365
=LET(in,A1:A100, at, SEARCH("@",in)-1, MID(in, at, LEN(in)-at)
and third column
=LEFT(A1,SEARCH("@",A1)-1)
- the gmail is the question. i need the fomula that was used to get the results.
