I have downloaded the wsp file from this link to export selected items from list. i have succeeded as well, but the problem is i have two "lookup" columns. when i export the list items(selected or all) to excel, these two lookup columns not exporting exactly what is there in the list. lets say i have "Vendor" in one lookup column, after exporting it will be "2;#Vendor". so i want to see only Vendor not the symbols and numbers. i do not know from where it is capturing numbers and symbols. other list column has "Cordy, Inc", in excel "1009;#Cordy, Inc". please guide me. THE LINK:"http://www.codeproject.com/Articles/400720/SharePoint-2010-Export-Selected-Items-to-Excel"
Submit an article or tip