I have had that happen before and the way I fixed mine was that where
ever my activecell was located I counted columns from there. Example:
If my active cell  was C1 and I wanted text to go in E1 I had to choose
column number  2 instead of 5. hope that helps.