Copying partial info from a cell

M

Mirshy

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
 
F

Frank Kabel

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!.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Conditional concatenating!!! 3
List all tables, including document structure 0
Formating bolded text exclusively. 0
copy specific cells from sheets if the information is correct 3
Merging from an Excel file with graphics 1
Write formula for simple copy and paste to another cell 1
Referencing cells in consecutive rows 2

Top