Hi.
I think I need a macro? to transfer the information in 1 row across columns 6,5 & 4 into 1 column (4) in 1 row. This is so I can use the information in a SatNav that only reads the first 4 columns and the address needs to be shown in the SatNav on separate lines. Someone has given me what I...