I am using Excel 97. In Column A I have numbers 1234432156788765 that
I have been using the following code to copy to Column B and put a space
between each 4th number, 1234 4321 5678 8765.

=MID(A2,1,4)&" "&MID(A2,5,4)&" "&MID(A2,9,4)&" "&MID(A2,13,4)

For some reason when I try to use this now all I get in cell B2 is the
code, =MID(A2,1,4)&" "&MID(A2,5,4)&" "&MID(A2,9,4)&" "&MID(A2,13,4). It
doesn' t copy the numbers over. I tried to set the numbers in column A
to text and general numbers, but it still would not copy. Any help is
appreciated.

TIA