SORTING DATA

A

Ali

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
 
P

PC

Try this

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

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

PC
 
A

Ali

Thankyou so very much...it helped cheers

PC said:
Try this

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

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

PC
Click to expand...
 
Top