I hope this is simple. I am trying to make a formula which can replace part of the value on the fly.
The formula will be in Column C and dragged down. =A1&" - "&B1 is what I am using. I need to change MANHOLE to MH each time it runs into that value.
A1="48inch MANHOLE" B1="R1234" C1="48inch MH - R1234"
A2="24inch INLET" B2="R1234" C2="24inch INLET - R1234"
A3="12inch END CAP" B2="-" C3="12inch END CAD - -"
Thanks for any pointers.
The formula will be in Column C and dragged down. =A1&" - "&B1 is what I am using. I need to change MANHOLE to MH each time it runs into that value.
A1="48inch MANHOLE" B1="R1234" C1="48inch MH - R1234"
A2="24inch INLET" B2="R1234" C2="24inch INLET - R1234"
A3="12inch END CAP" B2="-" C3="12inch END CAD - -"
Thanks for any pointers.