Hi there - I am a real novice at VBA. I have an Excel table with names of books in a cell a long with the author and are entered as such e.g. "To Kill a Mocking Bird" - Harper Lee
I would like to be able to have the dash as well as the text that follows to be normal text "To Kill a Mocking Bird" - Harper Lee. Can this be done?
Thanks
Dickson
I would like to be able to have the dash as well as the text that follows to be normal text "To Kill a Mocking Bird" - Harper Lee. Can this be done?
Thanks
Dickson