• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

How to get 1st 2 character in cell of a column in excel

thanks
0
turbot_yu
Asked:
turbot_yu
  • 5
  • 4
  • 2
3 Solutions
 
Amitkumar PSr. ConsultantCommented:
Use the following function

=LEFT(<CELL NO>,2)
0
 
turbot_yuAuthor Commented:
seems not correct.
0
 
SiddharthRoutCommented:
It is not the cell number but the cell Address for example if you want to get 1st 2 character of cell A1 then the above formula will be

=LEFT(A1,2)

Sid
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
turbot_yuAuthor Commented:
I tried, it gives TRUE of FALSE
0
 
SiddharthRoutCommented:
May I see the excel while where you are trying?

Sid
0
 
turbot_yuAuthor Commented:
Tried, cannot upload
0
 
SiddharthRoutCommented:
You need to click the file upload button at the bottom of the below text box.

Also where exactly are you putting the formula and what exact formula are you using?

Sid
0
 
turbot_yuAuthor Commented:
ok this time
Book1.xlsx
0
 
SiddharthRoutCommented:
That is because you have entered the formula twice in the same cell :)

Select the cell and press F2, you will the two formulas, one below the other :)

If you want delete and type it again :)

Sid
0
 
Amitkumar PSr. ConsultantCommented:
turbot_yu,

reviewed your sheet, you have added the following

in D6,
=LEFT(C6, 3)
=LEFT(C6,2)

in D7,
=LEFT(C7, 3)
=LEFT(C7,2)

in D8,
=LEFT(C8, 3)
=LEFT(C8,2)

remove the 2ne line in each formula and then check.
0
 
turbot_yuAuthor Commented:
thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now