Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Finding different nums than entered
Name: laniblaze Date: December 11, 2008 at 07:30:09 Pacific OS: xp CPU/Ram: 2 Gig Product: Dell / INSPIRION 2200
Comment:
Hi,
In excel 2007 I have over 300,000 entries. When an employee or customer searches for a number, for example, 973-478-9784 how do I make it so it finds the number if they only type 9734789784? Right now it only finds it when they type it with the dashes. I need to do this for phone numbers and product numbers.
Name: Jennifer SUMN Date: December 11, 2008 at 08:22:55 Pacific
Reply:
How are the cells formatted?
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
0
Response Number 2
Name: laniblaze Date: December 11, 2008 at 09:00:32 Pacific
Reply:
Hi Jennifer,
Thank you for your prompt reply. I believe they are just formatted as numbers.
0
Response Number 3
Name: Alphawave Date: December 14, 2008 at 21:23:39 Pacific
Reply:
Is it possible to insert another field (column)? If so, you could repeat the hyphenated numbers with the same number, minus the hyphens and have both included in the search.
To easily remove the hyphens, try this formula:
=SUBSTITUTE(A1,"-","") where A1 is the cell containing the numbers with hyphens.
Summary: 2007 Office is almost a completely different animal than earlier versions; in functionality, and especially in appearance. You could Google for 2007 training. Here's a site I discovered and find very...
Summary: I have lost an important file that took me ages to create. I saved the item under a removable disc, then when trying to go back to that same file it is no longer there. The item was saved and when i t...
Summary: Hi, This solution allows you to use a range, rather than entering individual cell addresses. It copes with empty cells and cells with a single space in them. With data in A1 to D1 enter this into any ...
0 
