J JE McGimpsey Feb 4, 2005 #2 One way: Type into A1. In the cell you want the text to appear, enter =A1