Originally posted by @Chris Shepard:
Made another offer that I will syndicate to some friends on a 5 plex on 4 lots today as well. Lots of stuff going on.
I've got an excel question. How does everyone format the names on their lists for mailing?
I have tons of businesses, trusts, and individuals I want to mail, but their names are all not perfect and ready to mail. There's about 1500 people on the list... Is it really worth it to go through each one personally? Do you guys outsource? Does anyone have a program that does it automatically?
I'd try using the =CONCATENATE formula to combine cells, then use " " or ", " as spaces or commas.
For example: =CONCATENATE(Q2," ",W2,V2,", ",R2,", ",S2, " ",T2) where Q2 would be the site address, and W2 and V2 would be suite or Apartment number, R2 would be city.
There are other formulas you can use to deconstruct a cell such as =find and =search, and =mid, and =right in some combination, but that's going to get really complicated.