Pull 1st 4 letters from another cell

  • Thread starter Thread starter Linda RQ
  • Start date Start date
L

Linda RQ

Hi Guys,

I have cells with a person's name in it. Is there a function or formula to
enter in the cell next to that one that will only show the first 4 letters
from the original cell.

Cell A1 is Amanda

Cell A2 would be aman

Thanks,
Linda
 
With 'Amanda' in A1, this formula will rturn 'Aman' in any cell you choose
to enter it,
=LEFT(A1,4)
Regards,
Alan.
 
Thanks, Roger and Govier. I was just about to post that I found it. I
couldn't leave work until I did this so I was just looking around and found
that you can click on each function and you get a little explaination of
what it does. Is there a list of functions and what they do all on a page?
Clicking on each one did take a bit if time and there are a lot of functions
in there <g>

Linda
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Add ^ to a row of cells containing letters 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Import Comments 3
Excel JUMP FROM SEARCH BAR TO RESULT 3
Excel Use COUNTIF across a range of cells with formulas 0
Excel Named Ranges and Conditional Format 3

Back
Top