134 PCWorld APRIL 2020HERE’S HOW EXCEL FUNCTIONS AND TOOLS
have five digits and some
have six, enter the
following command in cell
E2: =RIGHT(D2,6), then
copy from E2 down to E3
through E16. Done.
Column E now contains ZIP
codes only. However,
column D still has both
states and ZIP codes.15 & 16. LEFT &
LEN
Use this function to
separate the states
from the ZIP codes.
Enter the following
formula in cell F2:
=LEFT(D2,LEN(D2)-6),
then copy down from F2
to F3 through F16.
Basically this formula says
go to cell D2, count 6
places from the left and
remove those characters,
leaving the remaining characters in cell D2
(regardless of how many). As long as one
piece of information inside a cell is unique,
you can use that information to add, delete,
or replace other data inside that cell.
To move or manipulate the data in
columns E or F (which contain formulas),
highlight the column and choose Copy,
move your cursor to another column, andchoose Paste Special > Values, then
click OK.- PMT
Need a new car and want to stick to a
budget? Use this handy function to
determine how much your payments
would be on that new car you just took for
a test drive. The process is simple: Enter
Using the RIGHT, LEFT, and LEN functions.