Snasui Excel Forum

Hi Dear,

I need your help to extract name from mail address separate by comma in a cell.the formula would list the names down.

I attached a template

Thanks

..

Hi Guy,

Try this.

I think my formula is a little bit too long , It might have a proper one from other members.

A3

=IFERROR(TRIM(LEFT(MID(SUBSTITUTE($A$2,";",REPT(" ",200)),ROW(A1)*200-199,200),SEARCH("@",MID(SUBSTITUTE($A$2,";",REPT(" ",200)),ROW(A1)*200-199,200))-1)),"")

Norkaz

Thank you