I am currently taking a long string and converting it from text to
columns. I am trying to extract the text in between the "Title:" and
"Start" As you can see below, when I convert to columns, I have
different columns and the number of cells the title occupies varies as
well.

A B C D
E F G
Template Title: National Folk Festival Start
Title: Washington, DC (one day
tour) Start
Title: The Parks Start
Title: The Parks Start

In the end I need it to look like
A B C D E
National Folk Festival
Washington, DC (one day tour)
The Parks
The Parks

I have a lot of rows of this type of data, so I need VB to do it
automatically for me. Any help you can give is appreciated.