Hello All,

I have an interesting question that needs some answering.

I have a set of columns loaded with information. One of the columns has a set of information in it that relies on 5 columns. Here is an example:

Example 1:

Column B
AREA:80:FORT ERIE:_TOWN_UNKNOWN:BERTIE ST

Column E
80

Column H
FORT ERIE

Column I
(BLANK)

Column U
BERTIE

Column V
ST

Example 2:

Column B
AREA:80:FORT ERIE:_TOWN_SMALLVILLE:BLACK CREEK RD

Column E
80

Column H
FORT ERIE

Column I
SMALLVILLE

Column U
BLACK CREEK

Column V
RD

Attached is a spreadsheet of what it should look like.

Book2.xlsx

I need the process to be automated by a macro to scan the columns and automatically input that info. into Column B with the template:

Area:Column E:Column H:_TOWN_Column I:Column U Column V