I ran into another situation where I could really use your help! First, I have text in G2 that has {J} and {K} that needs to be substituted for. The substitution text for {J} is in position J2 and the substitution text for {K} is in position K2. Do you know of any formulas that would substitute the botttom two formulas (assuming they are correct) into one formula?
=SUBSTITUTE(G2,"{J}",J2)
=SUBSTITUTE(G2,"{K}",K2)
P.S. Do you think something like this would work?
Thanks,
DukeURL
Bookmarks