Pull 1st 4 letters from another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda RQ - 22 Jul 2006 00:16 GMT

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

Reply to this Message

Roger Govier - 22 Jul 2006 00:33 GMT

Hi Linda

in cell A2
=LEFT(A1,4)

Signature

Regards

Roger Govier

> Hi Guys,
>
[quoted text clipped - 10 lines]
> Thanks,
> Linda

Reply to this Message

Alan - 22 Jul 2006 00:35 GMT

With 'Amanda' in A1, this formula will rturn 'Aman' in any cell you choose
to enter it,
=LEFT(A1,4)
Regards,
Alan.

> Hi Guys,
>
[quoted text clipped - 9 lines]
> Thanks,
> Linda

Reply to this Message

Linda RQ - 22 Jul 2006 00:55 GMT

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

> Hi Guys,
>
[quoted text clipped - 8 lines]
> Thanks,
> Linda

Reply to this Message

Rate this thread: