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 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


--
glwday
------------------------------------------------------------------------
glwday's Profile: http://www.excelforum.com/member.php...o&userid=32336
View this thread: http://www.excelforum.com/showthread...hreadid=520976