One of my responsibilities is the deployment of software around our network. I often get lists of users and their computers names but usually not in the format I need.

For example I get

User PC
S01234 1712265
K11567 1287997
B09768 2524387

What I need is for each PC name to have it's site prefix added

User PC Prefixed Result
S01234 1712265 ST1712265
K11567 1287997 LO1287997
B09768 2524387 BS2524387

Currently I have to sort on user name and =CONCATENATE("ST",B2) copy that down the users beginning S =CONCATENATE("LO",B3) for users beginning K and so on.

Is there a way of using LEFT so that it goes something like this
IF LEFT(A2)="S" Concatenate ("ST",B2) ELSE IF LEFT(A2)="K" Concatenate ("LO",B2) ELSE IF LEFT(A2)="B" Concatenate ("BS",B2)

Thanks in adavance