Dear all,
I have to load CSV file on sage...now when i want to create ACCOUNT
NAME...it has to be only 8 digits. Is there anyway i can use some kina of
formulae which can take out 1st 8 digits/figure of the name i am puting as
address. I hope following address can be of some help

1 Berbris Court i need to make it only 1BERBRIS ....

Actualy i have got round about 300 addresses to create account for...so u
can understand that making 300 accounts with exact 8 digits is going to take
me ages...

any kina of helo will be much much appreciated

cheers and thanx in advance