Prev: how to remove the page break lines in a spread sheet,
Next: Cancel Read Only
From: zyus on 22 Mar 2010 04:22
I hv this sample data in excel

019-1234567
019 1234567
019#1234567
%0191234567

My question

1) How to delete spacing, dashes, character etc leaving the number only..in
my above sample the clean data that i want to get is 0191234567

2) I tried to use replace function (to delete dash,space etc) but the
leading 0 will not be displayed.

What will be the best approach?

Thanks
From: Stefi on 22 Mar 2010 05:22
There are several options for displaying leading zeros depending on the way
you want to use the strings.
1. Custom formatting the cells with format code "0000000000" (10 zero digits).
2. Convert to text with =TEXT(A1,"0000000000")
3. Format a range as Text and Copy/PasteSpecial-Values the result of the
above formula.


--
Regards!
Stefi



„zyus” ezt írta:

> I hv this sample data in excel
>
> 019-1234567
> 019 1234567
> 019#1234567
> %0191234567
>
> My question
>
> 1) How to delete spacing, dashes, character etc leaving the number only..in
> my above sample the clean data that i want to get is 0191234567
>
> 2) I tried to use replace function (to delete dash,space etc) but the
> leading 0 will not be displayed.
>
> What will be the best approach?
>
> Thanks
 | 
Pages: 1
Prev: how to remove the page break lines in a spread sheet,
Next: Cancel Read Only