Hi, I have listed of data e.g.
Cell A1 - B100 26 Church Ponds CO9 3BZ add new box
Cell A2 - G4 add new meter 15 Highfield Road CV1 1AA
Cell A3 - Product 1000 27 Low Road L1 1AA increase supply
Cell A4 - CF11 1AA 2 New Street g7 remove roof
In cells B1 to B4 I wish to pull out the...