I have tried to figure this out.My firm enters client information in 2 firelds "First Name" and "Last Name"I created a custom Report and used "Name" in order to combine them like so.When I run the report it looks good.When I exports it however - it does not.ie.<a href="/00v0f00001kd5mw" target="_blank">Peter Edelson</a>How to I get it to export without all that?
It depends on what object you're using, but it sounds like you can just concatenate the two fields in your Excel spreadsheet.In a different column, you can type "=CONCATENATE(FirstNameField," ", LastNameField)"