Changing Domain names

[briansterling]

So I'm migrating a multitude of workstations from one domain to another and I have a very useful program to help me with this. One of the great features is it can draw from an excel file to rename the computers in the same process which is necessary since the new domain has different naming standards than we have now. Can anyone help me understand the formula/conditional formatting necessary to produce the type of results in the example table below?

Old Domain Name	New Domain Name
LOC(ation)5001(item ID)	USLOC-LT-05001
LAP5549	USTUS-LT-05549
SUR5112	USTUS-LT-05112
CHA2745	USCHA-LT-02745
CAR2786	USCAR-LT-02786

<tbody>
</tbody>

I would need a way to:
- Isolate the last 4 numbers and add a zero
- Take the first three letters and make bring them over after inserting "US"
*but not if the three letters are "LAP"
- Insert the "-LT-0" between the location and the inventory number.

With how our names are now the results are bound to be quite messy but it would save a lot of time in giving me a base-line that I can go through and make corrections after the fact. I appreciate any assistance that is provided.

 

[shg]

How do you get these?

LAP5549 USTUS-LT-05549
SUR5112 USTUS-LT-05112

Otherwise,

	A​	B​	C​
2​	LAP5549	USLAP-LT-05549	B2: ="US" & LEFT(A2, 3) & "-LT-0" & RIGHT(A2, 4)
3​	SUR5112	USSUR-LT-05112
4​	CHA2745	USCHA-LT-02745
5​	CAR2786	USCAR-LT-02786

 

[Rick Rothstein]

- Take the first three letters and make bring them over after inserting "US"
*but not if the three letters are "LAP"

Based on your example...

Are we supposed to conclude that if the first three letters are "LAP", they should be changed to "TUS" before the "US" is placed in front of them?

Why are the first three letters "SUR" changed to "TUS" before the "US" is placed in front of them?

 

[briansterling]

Hey guys,

I figured this out. Should have put some actual effort in before crying wolf online.

Thanks