Problem With Text & number format

Z

zyus

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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show number in thouands using Formats 7
Adding in leading zeros and a space to a text field in a table 4
Need to remove cells with variable data 3
Problems with number formats when using Find/Replace 3
Formating text in cells 3
Find and Replace 3
Format number as text on import 3
Extract number from text string based on number's format? 16

Top