I have thousands of wire tags to make for a very large water treatment plant in San Diego Ca. which I have already input where they are comming from and going to, in cell A1 on down! Now in the next cells to the right which would be B1 on down I am trying to create a formula so I do not have to re-type again.
Example of the tag in A1: RIO 2-CR6105-14-(34) to VCP 60.0283-TB2-2
Example of the tag which would be in B1 after creating the formula.
The formula would take this wire tag which is comming from thr RIO 2 cabinet and change it so as when we put the tag at the VCP it would read:
VCP 60.0283-TB2-2 to RIO 2-CR6105-14-(34)
Example of the tag in A1: RIO 2-CR6105-14-(34) to VCP 60.0283-TB2-2
Example of the tag which would be in B1 after creating the formula.
The formula would take this wire tag which is comming from thr RIO 2 cabinet and change it so as when we put the tag at the VCP it would read:
VCP 60.0283-TB2-2 to RIO 2-CR6105-14-(34)