Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

Common questions and answers.

Entire collection of data resources.

Latest Data News

RSS Feed icon


Census 2020 Oversight Hearing

Census is in trouble: decennial and economic

Opoid Use and Labor Force Participation

The Future of Free Public Access to Government Information

Data Services Knowledge Base


I have some census characteristics that I want to put into GIS. However, I am having trouble doing so because the FIPS codes in my data are represented as numbers; e.g., 1 for Alabama instead of 01. Likewise, Autauga county is represented as 1 instead of 001. I need an ID variable for Autauga county, Alabama that looks like 01001.

How can I convert numeric data back to text in Excel? Right now, state is in one column and county is in the next column.


Assume that your state code is in column A and your county code is in column B.

Column C will be the text version of column A. The following is the formula that should be used for cell C2:


Column D will be the text version of column B. The following is the formula that should be used for cell D2:


Column E will be the combination of columns C and D: =CONCATENATE(C2,D2)

The example is presented in the spreadsheet below. If you do not understand these formulas or how to apply them, you can open up the spreadsheet and paste your values for state and county in columns A and B and the modifications will show up in columns C – E.



Related Question Groups: