Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2013, 11:35 AM
borninscorpio borninscorpio is offline Need help searching without defined characters Windows XP Need help searching without defined characters Office 2010 32bit
Novice
Need help searching without defined characters
 
Join Date: Jul 2013
Posts: 3
borninscorpio is on a distinguished road
Default Need help searching without defined characters

Ok. I have a spreadsheet with 50,000 user names in column one. I would like to search for any usernames that have a particular setup. I would like to find all of the usernames that are three letters, followed by four numbers...they could be any letters or numbers, just in that certain pattern. I don't know how to conduct this search.

I have scoured the internet, but am not able to find an answer... I hope someone can help me..

Thanks



Reply With Quote
  #2  
Old 07-29-2013, 11:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need help searching without defined characters Windows 7 64bit Need help searching without defined characters Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi perhaps :
Code:
=IF(and(len(a1)=7,istext(left(a1,3)),isnumber(right(a1,4)+0)),"true","false")
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help searching without defined characters FileSystemObject Compile Error: User-Defined Type Not Defined gsrikanth Excel Programming 2 03-28-2022 06:32 AM
Need help searching without defined characters Captions, self defined stresscalcs Word 9 01-29-2015 04:47 PM
Need help searching without defined characters Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err tinfanide Excel Programming 2 06-09-2012 10:19 AM
Need help searching without defined characters Application-defined or Object-defined error Manit Excel Programming 4 12-08-2011 07:35 PM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft