I need help figuring out how to add a prefix to an existing description in a project table, generated from the project number.
Here's a sample of my data:

PROJECT NUMBER DESCRIPTION
01200000 Completed Projects
01601530 Steele Sub

I would like the Descriptions to read:
01200000 MO-20 Completed Projects
01601530 MO-60 Steele Sub

The state, “MO,” comes from the first two digits “01” and the coop, “60,” comes from the second two digits. I have a table of a thousand or so projects in an Access database that I need to amend the descriptions of to include these prefixes. Is there a simple way to do this in Access or in Excel without writing code?

I can see the -60 and -20 but why does 01=MO ? Are there other values in use? Is there a lookup table ?

That is just the system the database administrator set up. These are the only states we're involved in:

01 = MO
02 = KS
03 = AR
04 = OK
05 = IL
07 = TX

We do not have a lookup table. The descriptions and project numbers were entered into a table simply as text or numbers. We are getting ready to migrate to new software and are trying to get our descriptions cleaned up before they bring them into the new application.

Well a lookup table would be better but if this is just a once-off exercise then you could run a parameter query several times - once for each state and do all the changes that way.

Update ProjectTableName set [description] = [Enter state letters] & "-" & Mid([project number] ,3,2) & " " & [Description]
where left([project number] ,2) = [enter state numbers]

So run this the first time entereing MO and 01 then run it again using KS and 02 and so on.

Make sure you have a good backup before testing and executing.

Yes, this will be a one-time thing. I will try that. Thank you!