|
In response to
"help, please: is there an easy way to convert a list of e-mail addresses in excel to just names?"
by
b.
|
Do you need first and last name in separate columns?
Posted by
decline (aka Decline)
Aug 5 '09, 10:36
|
if not, first thing you need to do is make sure the cells are not hotlinks (clickable and usually blue). To do this, right-click on one of them and select 'Remove Hotlink'. Then highlight that cell and use the format painter to remove all the rest.
Then use this formula to get the names (Assume email addresses are in column A:
=LEFT(A2,FIND("@",A2)-1)
copy that down your list. Should give you FIRST.LAST name in column B. You can then split those if needed a bunch of different ways.
|