| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
Linear Mode
