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