You could custom format to create the look of 1201 00

Custom 0000 00

To change them to text.

=LEFT(A1,4) & " " & RIGHT(A1,2) entered in B1

Double-click to copy down.

When happy, copypaste specialvaluesOKEsc and delete column A


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 07:49:01 -0700,
wrote:

I have a file with a column that contains numbers that have six digits. I
need to add a space between the last two digits in this very long column of
numbers. Is there an efficient way of doing this? Example: 120100 needs to
be 1201 00