Wire Tags

mstilwell

New Member
Joined
Aug 20, 2007
Messages
37
Hello , I am making several thousand wire tags for a water treatment plant which need to be installed at each end of the cable runs. What I have made so far is tags for one end of the run not the other. I am looking to create a formula to change the tag on the other end so that instead of it saying
1234
to 5678
it would now say
5678
to1234 thanks in advance for your help on this!
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
One more thing I forgot to ask! If, 1234 to 5678 is in cell A1 and 5678 to 1234 is in cell B1 what would this formula read so it would automatically fill in B1 as I type my complete tag number in A1?
 
Upvote 0
If you are wanting something that updates cell B1 character by character, I think some VBA code would be required. If you're OK with waiting until you finish typing in cell A1, the following formula in cell B1 will do the reverse tag with any number of character on either side of the "to". Notice the spaces before and after the word "to" in the FIND commands. This allows the formula to ignore the letters "to" if they appear within either destination.

=MID(A1,FIND(" to ",A1)+4,(LEN(A1)-FIND(" to ",A1)+3))&" to "&LEFT(A1,FIND(" to ",A1)-1)

A few examples, including a few with the letters "to" within the destinations:
Book3
ABCD
11234 to 43214321 to 1234
22234 to 442442 to 2234
312 to 106E223106E223 to 12
4106E201 to MCC-1AMCC-1A to 106E201
5UPS 1 ckt 6 to Operator Console AOperator Console A to UPS 1 ckt 6
6Operator Console B to UPS2 ckt 9UPS2 ckt 9 to Operator Console B
Sheet2
 
Upvote 0
Maybe this? Formula copied down.

Excel Workbook
AB
11234 to 43214321 to 1234
22234 to 442442 to 2234
312 to 106E223106E223 to 12
4106E201 to MCC-1AMCC-1A to 106E201
5UPS 1 ckt 6 to Operator Console AOperator Console A to UPS 1 ckt 6
6Operator Console B to UPS2 ckt 9UPS2 ckt 9 to Operator Console B
7
Reverse
 
Upvote 0
Hello, I have cells which I enter a wire size such as #14, #8, #4/0, etc. To the right of the cells I have entered is another cell which I want to recognize the size of the tag which needs to be ordered for the size of the wire I have inputed. Example:
A1) 14
B1) 2HS-187-2-WT

A2) 8
B2) 2HS-375-2-WT

A3) 4/0
B3) 2HS-75--2-WT

I have a multiple of different tag serial numbers as you can see in the B cells in the example. I am looking for it to recognize what serial number to put in cell B when I input the wire size in cell A. Thx
 
Upvote 0
Hello, can this formula be made so I can input the formula in B cells only without having to input any other cells than A. Possibly by inputing all the serial numbers and wire sizes in the same cell? Thx.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top