Hi,
i have more than 10,000 pharmacy codes starting like below, i need a formula to erase all the zeros and the alphabet before the number but not the zero after the number eg: 1, 100, 20101, 3000 etc etc. Thanks for your help in advance. [TABLE="width: 80"]
[tr]
[TD="class: xl63, width: 80"]P00000001,
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00000002
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00000100
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00020101
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00030000
Raaj.
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]