So, I copied a long list of addresses, phone numbers, etc into an excel spreadsheet. I stuck it on tab 3 because I figured I could somehow link the info I wanted to keep on tab 1, and in the format I desired. So far no luck.

Here is an example of how it is formatted currently-

Calvary Chapel Ellensburg 1.9 miles

840 Cowboy Lane Ellensburg, Washington 98926
Phone: 509-925-1651 Email:taddscheffer@gmail.com
Visit Website Get Directions



Now, if I could have my perfect world, I would be able to have the needed information copy into a mailing label template. The above same is repeated with different addresses in one vertical column a few hundred times. The pattern is consistent, i.e. the amount of spaces from one name to the next is always the same. Copying it into a mailing label template would be great, even better (though I doubt it is possible) would be if the distance ("1.9 miles") could be deleted from the name and if the words "email:" could be deleted from each email. I don't know if excel can do that, but I know if does a lot more than I know about. I mainly use it for financial tables and formulas, so this formatting of info is not familiar to me.

Hope there is an answer, thanks for the help.