Data Modification? .....

I know this has to be a lot easier than what I'm figuring it to be but I can't seem to figure out how to modify data based on criteria (macro or conditional formating or whatever). I'm leaning towards a macro but I've never really used macros let alone built one.

My situation is this... I have a large list of movie titles (personal collection) and I've decided I want to change the title format. This list is quite large and I don't want to manually change these titles. Specifically, I want to change titles that begin with the word "The" and place this at the end of the title (ex. "Big Lebowski, The"). Any ideas on how I can get this done?

You could use a formula such as this one, and when you're finished copy and paste values over the original entries:

Please Login or Register  to view this content.

Actually I figured out a quick and simple temporary solution.

I created the following:

Please Login or Register  to view this content.

595 is obviously where my titles begin with "The" so I started it there to the end of those specific titles in a loop. Granted this isn't the best method but since I'm new to VB Macro programming, the only thing I had to go by was basic logic. And of course this worked for what I needed but I would definitely like to know how to make it better.

For instance... I'm sure it would be more efficient if I were to create a "check" to make sure the title actually begins with "The" and change it if it meets this criteria. This way I can apply this loop to the entire list and not have to worry about running it anytime I want. Right now it will run again removing the first 4 characters regardless.

I was never a real big fan of Excel but now with the use of Macros it's starting to look a little more intuitive and functional. Are there any Excel ODBC drivers available or can I query Excel spreadsheets natively in IIS (with ASP)? I've developed a visual dashboard for work using ASPX that queries a MS Project file but I had to find the proper Project ODBC connection driver and install it first on our Intranet server. Anyway... are there any good online documents for VBA? Or better yet... any VBA book recomendations?