SORTING DATA
 

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

Try this

=LEFT(SUBSTITUTE(A1," ",""),8)

Adjust A1 to reflect the cell with the address and then copy down

PC


"Ali" wrote in message
...
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

Thankyou so very much...it helped cheers

"PC" wrote:

Try this

=LEFT(SUBSTITUTE(A1," ",""),8)

Adjust A1 to reflect the cell with the address and then copy down

PC


"Ali" wrote in message
...
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