| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data in a master sheet | Excel Worksheet Functions | |||
| Sorting data in a table by the header of a column? | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
| data sorting problem | Excel Worksheet Functions | |||
| Help in Sorting Data Please! | Excel Worksheet Functions | |||
Linear Mode
