Link to home
Start Free TrialLog in
Avatar of turbot_yu
turbot_yuFlag for Singapore

asked on

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

thanks
ASKER CERTIFIED SOLUTION
Avatar of Am P
Am P
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of turbot_yu

ASKER

seems not correct.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I tried, it gives TRUE of FALSE
May I see the excel while where you are trying?

Sid
Tried, cannot upload
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
ok this time
Book1.xlsx
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thx