$$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 --

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 waheedb...@gmail.com 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