Extract Email ids

[Sekars]

Hello Friends

I need to extract email ids from Column A to column B light yellow cells by formulas.

We need to find the last space from right to left and from last space we need to extract.

thanks in advance

[shukla.ankur281190]

Try

B1=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",151)),151)) and drag down.!!!

[Sekars]

Hello Ankur

Thanks for your formula. For the input `Venki Govnida [email protected]' is shows result as `Govnida [email protected]' but the actual result need to be plot is `[email protected]'.

The Blank spaces inside excel in email ids are here it shows as *, but it is blank space in excel.

[shukla.ankur281190]

@Sekars....... as per your provided raw data... I had given you solution .... Can you upload your whole data once,,, so we can manage them easily...

[Sekars]

Hello Ankur

Please find the attached file.

thanks again for your formulas

[shukla.ankur281190]

Try

B2=TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A2,CHAR(160)," ")," ",REPT(" ",50)),50)) and drag down!!!

[Sekars]

Hello Ankur

thanks again for your revised formula, which is working well.

[cbatrody]

OR,

Try the following in B2:

=TRIM(RIGHT(SUBSTITUTE(A2,CHAR(160),REPT(" ",255)),255))

[shukla.ankur281190]

Glad to help you and thanks for feedback..