Jun 15, 2025
Оfftopic Community
Оfftopic Community
Forums
New posts
Search forums
What's new
Featured content
New posts
New media
New media comments
New resources
New profile posts
Latest activity
Media
New media
New comments
Search media
Resources
Latest reviews
Search resources
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Mobile
Phones
General Phones
Is there an Excel formula / trick to select all cells with a phone number? or "www."?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Tahj" data-source="post: 2202611" data-attributes="member: 775556"><p><strong>Is there an Excel formula / trick to select all cells with a phone number? or "www."?</strong></p><p></p><p>I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: </p><p></p><p>(###) ###-####</p><p></p><p>Yes, there is a space after the area code. Also is there a way to select cells that contains:</p><p></p><p>www.</p><p></p><p>I want to remove rows containing websites</p></blockquote><p></p>
[QUOTE="Tahj, post: 2202611, member: 775556"] [b]Is there an Excel formula / trick to select all cells with a phone number? or "www."?[/b] I have Excel 2007. I pulled names from a directory but I want to delete the rows containing phone numbers. All numbers have this format: (###) ###-#### Yes, there is a space after the area code. Also is there a way to select cells that contains: www. I want to remove rows containing websites [/QUOTE]
Insert quotes…
Name
Verification
Please enable JavaScript to continue.
Loading…
Post reply
Top