Search for character & return values on left and right

[mviggiano]

Hello,

I am trying to create a macro to search for a character (in multiple columns) and return the values on the left and right of the character into seperate columns.

I want to search for the underscore "_" and return the two numbers on either side of the underscore into two different columns.

Quick Example:
BKN010 BKN015 OVC065 05_05 A2973 RMK AO2 UPE0552 SLP080 P0000 T00500050=
-DZ OVC009 05_05 A2970 RMK AO2 SLP071=
-RA BKN007 BKN025 06_06 A2969 RMK AO2 RAB1935DZE1852 SLP070 P0001 T00580058=

In two seperate columns put:
05 05
05 05
06 06
I have attached an example spreadsheet with what I would like to accomplish.

Thanks in advance,
Michael