I am talking about actual novels brought for recreational purposes. As in manuals don't count. Also, I would like to know who and on what mission these were brought.
I did some research and even though I couldn’t find an exact number I did find a handful of books brought by different astronauts into space. These were:
"The Hitchhiker's Guide to the Galaxy" by Douglas Adams - taken by astronaut Michael Foale to the Russian space station Mir in 1997.
"The War of the Worlds" by H.G. Wells taken by astronaut Buzz Aldrin on the Apollo 11 mission in 1969.
"2001: A Space Odyssey" by Arthur C. Clarke - taken by astronaut Frank Borman on the Apollo 8 mission in 1968.
"Dune" by Frank Herbert - taken by astronaut Koichi Wakata on the Space Shuttle Discovery in 1994.
"The Martian" by Andy Weir - taken by astronaut Tim Peake on the International Space Station in 2016.
"The Right Stuff" by Tom Wolfe - taken by astronaut Robert Gibson on the Space Shuttle Atlantis in 1991.
"The Journals of Lewis and Clark" - taken by astronaut Michael Collins on the Apollo 11 mission in 1969.
"A Journey to the Center of the Earth" by Jules Verne - taken by astronaut Terry Virts to the International Space Station in 2015.
"The Time Machine" by H.G. Wells - taken by astronaut William Pogue on the Skylab 4 mission in 1973.
"The Moon is a Harsh Mistress" by Robert A. Heinlein - taken by astronaut Michael Collins on the Apollo 11 mission in 1969.
"The Invisible Man" by H.G.Wells - taken by astronaut Shannon Lucid on the Space Shuttle Atlantis in 1996.
"The Bible" - taken by various astronauts on multiple missions, including Buzz Aldrin on the Apollo 11 mission in 1969 ( The Bible that was taken up into space).
"The Lord of the Rings" trilogy by J.R.R. Tolkien - taken by astronaut Clay Anderson on the International Space Station in 2007.
"The Diary of Anne Frank" - taken by astronaut Daniel Tani on the Space Shuttle Discovery in 2007.
"A Tale of Two Cities" by Charles Dickens - taken by astronaut Eugene Cernan on the Apollo 10 mission in 1969.
"The Hitchhiker's Guide to the Galaxy" by Douglas Adams - taken by astronaut Samantha Cristoforetti on the Expedition 42 mission in 2014 https://www.cnet.com/culture/astronaut-reads-hitchhikers-guide-to-the-galaxy-in-space/.
"Roughing It" by Mark Twain - taken by Frank Borman on Gemini VII in 1965.
"Drums along the Mohawk" by Walter D. Edmonds - taken by astronaut Jim Lovell on Gemini VII in 1965.
In addition to The Rocket Fan's list, the nonprofit Story Time From Space has sent 23 children's books to the ISS for astronauts to read on camera (usually while they're located in the Cupola).