Copy the first two or three letters of a cell to another one

I want to Copy the first two or three letters of a cell to another one in Excel

On the face of it ..

Assuming cell A1 contains the text: ABCD
In B1: =LEFT(TRIM(A1),2) will return: AB
In C1: =LEFT(TRIM(A1),3) returns: ABC

The TRIM(..) part is optional, it's just there as a safeguard which removes
any extraneous* white spaces (not readily visible) which may be present
within the text entered in A1
*especially leading spaces in this example
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jerry" <Jerry@discussions.microsoft.com> wrote in message
news:2DC0719E-1E63-4F3A-8FAF-52214F5B9D37@microsoft.com...
> I want to Copy the first two or three letters of a cell to another one in
Excel

Hi Jerry,

Try:

=LEFT(A1,2)


---
Regards,
Norman



"Jerry" <Jerry@discussions.microsoft.com> wrote in message
news:2DC0719E-1E63-4F3A-8FAF-52214F5B9D37@microsoft.com...
>I want to Copy the first two or three letters of a cell to another one in
>Excel

"Jerry" wrote:

> Thanks a lot for this post.
I wanted to work on a huge volume of data and your suggestion was very
helpful and valuable

You're welcome, Jerry (from us) !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jerry" <Jerry@discussions.microsoft.com> wrote in message
news:A664708E-69F4-4C4A-8EA5-3D03046862CA@microsoft.com...
> Thanks a lot for this post.
> I wanted to work on a huge volume of data
> and your suggestion was very helpful and valuable