Thanks Raj, But the length of the numbers need not be fixed always. Anyways
I have already got the formula which does this task,
=RIGHT("00"&RIGHT(A1,LEN(A1)-MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1),6)
If you can get me the same task in MS Access it would be great.
Thanks again.
C
hi
question is not v clear... coud u plz gv sm more dummy data and
outcome results.
do u want only the last 3 digits of the data record along with three
preceding zeros? tht cud be done easily as:
=right(a1,3) and cell formatting customized as 00.
Pal.
rajeshpal2...@gmail.com
On Aug 14
Hi,
On the similar logic, can you please get me the formula for:
ABC Company 345
The final result must be 000345
The company name is not required, but the number along with the name must be
the output with 6 characters.
Thank you,
Ravi Megharaj
On Tue, Aug 11, 2009 at 7:56 PM, Chechu wrote:
Hi,
If you will have a "." and space separating the supplier name, you can
try: =RIGHT(A1,(LEN(A1)-FIND(CHAR(46),A1,1)-1)) where A1 is the cell
with the supplier name.
Hope it helps!
CC
On Aug 11, 3:43 am, Suhas wrote:
> Hi,
>
> We have a file which is downloaded from HTML page.
>
> The data