Your coworker created a workbook with a list of names and addresses. The state abbreviation and zip.


 Your coworker created a workbook delay a inventory of names and addresses. The narrate abbreviation and zip jurisprudence are stored in one cell per customer, such as NC 27215. You insufficiency to be effectual to designation these facts by postal jurisprudence to use bulk-rate mailing. The mismisappropriate Excel force is to:

 (a) Type 27215 in the cell to the suitable of NC 27215 and use Flash Fill.

 (b) Copy the facts to another post and edit each cell to delete the narrate abbreviations.

(c) Use the BREAK APART character to different the narrate abbreviation and zip jurisprudence.

(d) Insert a new post and retype the postal jurisprudences.