Skip to main content
Question

Exporting to excel appends characters to the user field

  • Mar 3, 2017 12:21 AM UTC
  • 0 replies
  • 51 views
When I export a report to excel, a user column (sales supervisor) exports to excel as "user name with the number being some random combination. How do I avoid this being appended in the excel file?
      This topic has been closed for replies.

      • ChrisChris
      • Qrew Corporal
      • Mar 3, 2017 12:23 AM UTC

      You can create a formula text field and export that instead:

      usertoname([user field])

      This will convert the user field to a plan text field.

      No problem.

      Make a new formula text field called [User Name] with a formula of
      UserToName([Sales Supervisor])

      Use that on your report instead. 
      Terms & ConditionsAccessibility statement