Export custom list to excel

Question

I'm using SharePoint 2007. I have created custom-list.

The list contains one column from "Person and group" type, show field: E-mail.

I fill in data in the list column and export this list to excel list.

In the Excel list, I see the Email with employee number.

It looks like: firstName_LastName_CW@bmc.com;#397

How can I export a custom list into Excel without the number?

ShurikEv · Answer 1 · 2011-07-04 06:10:23Z

up vote -1 down vote

Use calculated fields in excel sheet. Or in sharepoint list

answered Jul 4 '11 at 6:10

ShurikEv
32

	Welcome to SharePoint SE! While this helps to answer the question, we prefer more details such as why your answer works. Please edit your post with additional details. – Alex Angas Jul 4 '11 at 7:24
	You can't use a calculated field because calculated fields can't read look up fields like the people picker. Does anyone have a real solution? – user8060 Apr 26 '12 at 16:55

1 Answer