Need to list all values that begin with a certain series of numbers

I have a column of data that contains values such as 1111,1112,1113,1234 etc. - I need to find a way to list all of the values in the column that being with 111. If it worked, it would list the first 3 values, but not the 4th of my example dataset. Also, it can't include just a left 3 character function because some occasions will need to pull all the values begining with 11134 or something longer. How is this possible?

Any help is greatly appreciated.

If you have your values in column A, the following formula should be placed into column B to populate only values that begin with 111. Then, you just have to sort to remove the blank cells:

=IF(LEFT(A1,3)="111",A1,"")

The left() function will work on variables of any length in your example because you only care about testing the first three characters, regardless of the length of the string.

Hope this helps.

Thanks for the quick response, Captain. The issue is that the data is not on the same worksheet that I would like the formula. Data is in one worksheet, and then I have multiple tabs, each with their own unique "begins with" value in which I would like to use to get all of the values in the data that 'begin with' 111.

Can you please post the workbook? I'm not sure I understand what you're describing. In your original request, you mentioned only one column of data. Thanks.