View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Copy the first two or three letters of a cell to another one

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" wrote in message
...
I want to Copy the first two or three letters of a cell to another one in

Excel