Parse out zeroz

R

RL

I am looking to separate out an apartment number. I have data that looks
like this 000030 and it stands for apt 30. Is there a way to parse out the
zeros so I can get to just the non zero numbers?

I know I would have to look at each space and see if it's a zero, but is
this easy?

Thanks!
RWI
 
M

Marvin P. Winterbottom

if they are all zeros and numbers, just use the VAL(textstring) function
 
Top