Excel / Outlook help...

Excel / Outlook help...

I've got a massive list of names in an excel sheet that i want to import into outlook.

at present they take this format

Job Group | Department Name| Surname| First Name| Post Name


I need to do the following:

Take the first letter of the First Name, add it to the surname and add an email address on the end

e.g

Smith | Alan would become

asmith@companyname.co.uk

The email address would then be stored in a new column on this sheet.

The column would then imported into my Outlook contacts list


CAN IT BE DONE?????

Have you not got Access? Think it'd be easier in that.

good idea

im pretty wack at access but ill give it a go

There might be a way of doing it in excel with vlookup and if functions if access doesn't work.

heres how you do it....


In the column that you want to store the names add this:

=concatenate(left('firstnameCellAddress',1),secondnameCellAdress,"@companyname.co.uk")

then just drag it all the way down the list.


just saved me typing 1100 entries into my outlook contact book

Had just worked out the concatenate bit, but not how to get the only the first letter from the forename.