T thejakzons Jan 23, 2004 #1 If I have 9 digits in one column how can the next column be just the last 4 digits in the previous column? Thanks.
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 Jan 23, 2004 #2 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
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 Jan 23, 2004 #3 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
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
