Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry
 
Posts: n/a
Default 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   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


  #3   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Jerry
 
Posts: n/a
Default 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   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

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 11:51 AM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 02:29 PM
Macro to open workbook and copy and paste values in to orig workbo Dena X Excel Worksheet Functions 1 December 16th 05 12:13 AM
need to Copy or Move to active cell from specified range kaream Excel Discussion (Misc queries) 2 December 14th 05 09:12 AM
AUTOMATIC way to copy the value of a cell in one spreadsheet Mihalis4 Excel Worksheet Functions 2 December 2nd 05 07:49 PM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"