Selecting a list Census Block within a feature layer

AnthonyB

I am a newbie to ARCGIS pro. 

I have a feature layer that includes every census block in the county and one of the attributes for each census block is a field of 15 digit numbers labeled GEOID10.   see sample below

FID	Shape	STATEFP10	COUNTYFP10	TRACTCE10	BLOCKCE10	GEOID10	NAME10	MTFCC10	UR10	UACE10	FUNCSTAT10	ALAND10	AWATER10	INTPTLAT10	INTPTLON10
0	Polygon	19	13	2902	1025	190130029021025	Block 1025	G5040			S	31623	0	42.40741	-92.2661
1	Polygon	19	13	2902	1012	190130029021012	Block 1012	G5040			S	1714701	0	42.41826	-92.2374
2	Polygon	19	13	2902	1067	190130029021067	Block 1067	G5040			S	42781	0	42.38603	-92.2455
3	Polygon	19	13	2902	1017	190130029021017	Block 1017	G5040			S	219504	0	42.41964	-92.2722
4	Polygon	19	13	2902	1100	190130029021100	Block 1100	G5040			S	24776	0	42.35487	-92.2973

 

In a separate spreadsheet I have a list of GEOID10  numbers that I would like to select out of the census block feature layer so that I can remove or better yet hide the rest of the census blocks in that feature layer. 

see sample list below

GEOID10

190130027004007

190130027004018

190130027004037

190130027004040

190130027004045

190130027004046

 

Can anyone help me out with this?  I have tried to add the sample list directly from a spreadsheet, but it reads the geoid's in like this:

GEOID10

1.90E+14

1.90E+14

1.90E+14

1.90E+14

1.90E+14

1.90E+14

 

This doesn't not make for a good list even start with much.  And so please let me know how to read the sample list in properly if that indeed needs to be in arcgis as well.

Thanks

DavidPike

Try to play about with Text formatting in the xls, I know it doesn't always play friendly with arcgis, so try Excel To Table (Conversion)—ArcGIS Pro | Documentation 

The simplest thing to do is to add another column to our spreadsheet or table named something like 'visible' then put values of 'yes' in.

you'd then do a Join Add Join (Data Management)—ArcGIS Pro | Documentation whereby the 'visible' field value for matching GEOIDs would be 'yes'

Then a simple definition query whereby ,<YourField> == 'Yes'
Filter features with definition queries—ArcGIS Pro | Documentation

As Joe suggests, the key is initially to get this formatting issue sorted.