Hi,

Just wondering if someone could help me. I have a cell whereby I have an address. The address is split into 4 lines. Is there anyway I can copy each line to a new cell e.g

if Address is in A1, top line goes to B1, 2nd line to C1, etc

Any help would be greatly appreciated

Regards

Robert