Conversation Between arthurbr and akber.431

Please refrain from asking xl questions out of the forum

Can any one help me in the I want to Segregate Digits with Branch

for Eg. in Column A i have my invoice no. with 12 digits first four digits it inicates the Branch, so how i can do it in excel.

110800001200

i want to segregated 1108 -to know the branch with ref from inv#



thanks & regards
Akber