Excel Spreadsheet

T

thejakzons

If I have 9 digits in one column how can the next column
be just the last 4 digits in the previous column? Thanks.
 
O

Otto Moehrbach

Say the first column is Column A starting in A1. In B1 type "=Right(A1,4)"
(without the quotes) and hit Enter.
Drag this formula down as far as the data in Column A. HTH Otto
 
F

Frank Kabel

Hi
if you want the result as text use
=RIGHT(A1,4)

for numbers use
=VALUE(RIGHT(A1,4))

copy one of these formulas down
 
Top