Re: $$Excel-Macros$$ How to exclude a paritcular character from a series of number

=SUBSTITUTE(A1,".","") On Tue, Jul 26, 2011 at 4:27 PM, Shaik Waheed wrote: > Dear experts, > > I want to exclude a particular character from a number. > For example if the series is like this 01245-13. > and suppose I want to exclude "." from the series and want the remaining > number to be as

$$Excel-Macros$$ How to exclude a paritcular character from a series of number

Dear experts, I want to exclude a particular character from a number. For example if the series is like this 01245-13. and suppose I want to exclude "." from the series and want the remaining number to be as it is. Thanks, Waheed -- --