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
|