Search Results

You could be right, I was not able to hit enter in a cell to create a newline character. I am not yet sure if excel will take the address broken up by City State Zip etc. Thanks for your help though...

I have addresses like this

34 West Gutierrez Street Santa Barbara CA 93101; PO Box 6666 Santa Barbara CA 93120 USA United States;...

All one one line of a text file that I...

Hey Franklin, no dice on that, but I ended up figuring out a much simpler way to do it. I used:
sed 's/CONTACT.*/;/' file
to replace those lines with colons. I then deleted all newline characters...

Hey guys, I have a file that I've slowly been awking, seding, and greping for data entry. I am down to pull the addresses out to insert them into an excel file. Each address is a few lines, but i...