![]() |
|
|
|
#1
|
|||
|
|||
|
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 ![]() ![]()
|
|
#2
|
||||
|
||||
|
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 |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
FileSystemObject Compile Error: User-Defined Type Not Defined
|
gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
Captions, self defined
|
stresscalcs | Word | 9 | 01-29-2015 04:47 PM |
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err
|
tinfanide | Excel Programming | 2 | 06-09-2012 10:19 AM |
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 |