Creating a new column and populating values based another column values

Hi All,

I want to create a new column and populate values based another column in the same row. Example : I have an ID number in which 1st character denotes which team he represents, Based on the first character i need to populate a abbreviated team name in a new column.