Books > Help Center >
Your Account
> The Basics of Your GiftTool Account > Common features across all services >  



How do I remove the questions preceding the answers in Excel?

If you have included Questions or the Other 1 - 6 personal information fields in your online forms (Event, Appeal, Pledge-a-thon, Membership), both the question and the answer will appear in your Excel report for the Total Orders or Custom reports.

To remove the question that preceeds each response from your Excel file, follow these quick steps.

  1. Copy the exact text to be removed from the cell by:
    • Right click on the cell and highlight the exact text to be removed
    • Right click on the highlighted text and select copy
  2. Using the Replace function within the menu system at the top of your Excel document:
    • Paste the text to be removed into the "Find What" field
    • Leave the "Replace with" field blank
    • Click Replace All
    • This will delete all instances of the question in your Excel file.
  3. Save the file to your hard drive.

Alternatively, you can split the content of a cell into multiple cells in Excel.




Was this information helpful?
Yes   No




Search Help Center

Today's Top 10 Articles
  1. What happens if I forget my user name and password?
  2. How do I use Copy to create a new membership registration form?
  3. How do I register someone for hidden registrant types?
  4. How do I enable the Fund Name or Targeted Giving Program to appear on Tax Receipts?
  5. How do I add an event link to my website?
  6. Which version of Google Analytics am I using: Classic or Universal Analytics?
  7. How do I add automated GiftTool RSS event feeds to my website?
  8. How do I change a membership with a survey to the new Ask Questions?
  9. Sample Shipping Method: ShipEx Customer Account
  10. How do I restore an archived department?