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
|
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 |
Copy the first two or three letters of a cell to another one
Hi Jerry,
Try: =LEFT(A1,2) --- Regards, Norman "Jerry" wrote in message ... I want to Copy the first two or three letters of a cell to another one in Excel |
Copy the first two or three letters of a cell to another one
"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 |
Copy the first two or three letters of a cell to another one
You're welcome, Jerry (from us) !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jerry" wrote in message ... Thanks a lot for this post. I wanted to work on a huge volume of data and your suggestion was very helpful and valuable |
All times are GMT +1. The time now is 02:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com