turbot_yu
asked on
How to get 1st 2 character in cell of a column in excel
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried, it gives TRUE of FALSE
May I see the excel while where you are trying?
Sid
Sid
ASKER
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
Also where exactly are you putting the formula and what exact formula are you using?
Sid
ASKER
ok this time
Book1.xlsx
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx
ASKER