Exporting to Excel
Forum Home
SPAM Alert
Forum Guidelines
Having Trouble Accessing Our Forums?
Group Publishing Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        


Exporting to Excel Expand / Collapse
Author
Message
Posted 5/27/2009 1:02:36 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/15/2010 3:09:36 PM
Posts: 30, Visits: 631
When I export my participants to Excel, my parent fields get a little wacky.  I enter mom and dad's names using an "&" instead of "and" to save some space for when I actually do a printout...well, when this is exported is shows up as " David &amp Kathy " in the Parent field.  I am sure this is a tech glitch, but it is annoying.  Anyway to correct this other than re-entering everyone as " mom and dad "??? 

Thanks in advance for your help!!

Kathy

Post #56249
Posted 5/27/2009 1:12:53 PM


Moderator

Moderator

Group: Forum Members
Last Login: Today @ 1:20:04 PM
Posts: 613, Visits: 10,446
That &amp stands for ampersand.  There isn't any way to fix it that I know of.  It has to do with Excel (and Access) in MS Office, not really with Toybox. 

However, if you just do a quick search and replace in Excel, you should be able to replace the &amp with and or & in a few seconds!


Pictures taken on vacation at Lake Junaluska, NC.

Post #56252
Posted 5/27/2009 1:50:55 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 3/15/2010 3:09:36 PM
Posts: 30, Visits: 631
Thanks Peggy, I'll try that!  Was wondering if the issue was more with Excel - now I know!!

Kathy

Post #56268
« Prev Topic | Next Topic »

Permissions Expand / Collapse

All times are GMT -7:00, Time now is 5:34pm