J
Jerry
I want to Copy the first two or three letters of a cell to another one in Excel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
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
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
ExcelJerry said:I want to Copy the first two or three letters of a cell to another one in
N
Norman Jones
Hi Jerry,
Try:
=LEFT(A1,2)
Try:
=LEFT(A1,2)
J
Jerry
I wanted to work on a huge volume of data and your suggestion was veryJerry said:Thanks a lot for this post.
helpful and valuable
M
Max
You're welcome, Jerry (from us) !