Thank you for your help. I did what you suggested and checked how Calibre listed the column. My problem was that I didn't put underscores in place of the spaces. I fixed that on CC now it works great.
If I have CC scan for epubs on connect is that the only format that it can scan for or can it also scan for Kindle books? Also, am I right in assuming that wouldn't work if I had to reformat a device unless I had CC storing the books on the microSD card in the first place? If I did have it scan on connect, how would I go about doing that? Thanks again.