Hi there! I have a vba which adds a formula in I9:last row "=G9&J9". For some reason this formula is not working properly. When I change J9 to Text, then go back into the formula and hit enter it works. Is there a way to resolve this? Or do I need to change J9:last row to Text? If that's the...