Reply to thread

Message: [QUOTE="CarlJ, post: 5970102"] Hello everyone, I know many may have this same problem, I hope the answer helps a lot of people. I have a list of 1000 contacts that are in vertical order, not very database friendly. I would like to change the contact info so they are in colums cells not row cells. Some have email address, some dont . Their is a space between each orginal contact if that helps.I have tried may methods but none has worked Example From this Joe Smoe 122 W 123 Lake Phila,Pa 19120 954-633-5656 Billy Bon 122 W 123 Lake Phila,Pa 19120 954-633-4141 To this Joe Smoe | 122 W 123 Lake | Philadelphia,Pa 19120 |954-633-5656 Billy Bon | 122 W 123 Lake | Philadelphia,Pa 19120 |954-633-4141 The more suggestions the better . Thank you very much for your help Carl [/QUOTE]