90.2K

Verified Solution

Link Copied!

Comments 73076 Norman, OK 73077 Norman, OK 73072 Norman, OK 73071 73078 Horman, OK 73072 The objective is to concatenate (string together) text fields of address data so that the results can be easily coverted into mailing labels You can use the Concatenation function or the "&" operator to obtain the needed result. The name should be in first, middle, last order. Use the "W" symbol to separate name, street, and city, state, zipcode lines. Fill down the resulting formula using the autofil (magic button) capability. Notice that the resulting data could easily be copied and pasted into Word and the "values could be changed to carriage returns ("p) in order to obtain a mailing list format Where would you want the carriage return? Think D F 1 Lastname Firstname Initial Street City Zipcode 2 Davis Charles N 2401 5.E. Waverly Norman, OK 3 Peterson Linda A 2733 N. University 4 Davis John T 1188 SE. Highland 5 Dean Gwenn B. 8062 5 W. Hays 6 Jones Amy Y. 5964 W. Berry Norman, OK 73078 7 Coleman Randall N. 24765. Berry Norman, OK 73078 8 McDowell Jason U 9190 N.W. Waverly Norman, OK 73076 9 Livingston Andrew H 9283 NW. Duffy Norman, OK 73073 10 Curtis Acty U 2775 36th Norman, OK 73079 11 Davis Jo L 1576 NW. Jenkins Norman, OK 73077 12 Peterson Paul H 5662 N.E. Eufaula Norman, OK 73073 13 Peterson Thomas 8. 2337 N. 36th Norman, OK 73074 14 Campbell Andrea U 3345 5W. Park Norman, OK 73076 15 Murray 16 Johnson George Brad W 8592 W. Crawford Norman, OK 73079 P 4050 N.W. Buchanan Norman, OK 73079 17 Marcus Lawrence J 18 McDowell John 19 Davis Patricia 20 Brown Carl 21 Campbell Chris 22 McDowell David 23 Hamilton Amy 24 Sanders Randall 25 Hamilton Andrea LONG 352d. 2963 NW. Berry Norman, OK D 4248 E Main 2 8804 N.W. Jenkins Norman, OK 73071 P. 1547 5.W. Westfield Norman, OK 73072 A 5892 N. Westfield Norman, OK 73073 W 8046 W. 12th U 2363 E. Elm N. 4260 N.W. Alameda Norman, OK 73079 a 1517 NE. Hays Norman, OK 73078 26 M Chris L 2385 5. 24th Norman, OK 73072 27 28 Norman, OK 73078 Norman, OK 73074 Name Street City, State, Zipcode Think about copy and pasting the whole list of them. Don't let multiple addresses run together

Answer & Explanation Solved by verified expert

See Answer