Formula to get first 2 letter from a text box

Hello Friends,

I have a "Office" column with text data type and other column "Result". Lets say I enter "China" in "Office" I should get first 2 letters in "Result" column.

Please suggest

June 12th, 2014 5:07am

Hello Everyone,

I got it. I used LEFT([Office],2)

Free Windows Admin Tool Kit Click here and download it now
June 12th, 2014 5:16am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics