Extract text before @ sign

**burak2102** · 08-13-2012, 04:05 PM

Hello everyone. Its nice to be here. The case that brought me here is about my mailing lists. There are mails that I dont have names on my mailing list. I have a trick for this. But need VBA help for realisation.

On a csv file, lets say we have 5000 mails on column A. [email protected] is one them. Our macro should extract 'purple' from '[email protected]' and insert a blank column before email column and enter words to this new column that are extracted from the email addresses.

That will give me option to say Hello Purple... Capitalizing first letter also would be great.

Thank you all.

**tlafferty** · 08-13-2012, 04:14 PM

You don't need VBA to do this. Insert a blank column before column a and enter the following formula:
=PROPER(LEFT(b1,SEARCH("@",b1,1)-1))

**burak2102** · 08-13-2012, 04:34 PM

This is very practical. But how can I implement this to entire column in a practical way besides pulling the selection to the bottom of the 5000th row. Thank you.