Copying partial info from a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to copy just the last 5 letters from cell A1 to A2 and copy the formula down column 2. I used to know the formula, but can't remember it now. I was something like =A1(3,left) but now I get #REF!

Mirshy
 
Hi
try
=RIGHT(A1,5)

-----Original Message-----
I want to copy just the last 5 letters from cell A1 to A2
Click to expand...
and copy the formula down column 2. I used to know the
formula, but can't remember it now. I was something like
=A1(3,left) but now I get #REF!.
 
Back
Top