Jason-K -

Just an FYI. You don't need the CONCATENATE() function. Just use the
concateation operator (&), like so:

=LEFT(A1, 4)&" "&RIGHT(A1, 2)


"Jason-K" wrote:

If this info is in Column A...insert this in col B and paste down

=CONCATENATE(LEFT(A1, 4), " ", RIGHT(A1, 2))

You can then copy and paste values on top of Col A and then take B out

Note - this will destroy the formatting as "number"


--
//Jason


" wrote:

I have a file with a column that has six digits in the column. The file is
extremely long and I need to add a space beetween the last two digits in the
column,. Example: 120100 needs to become 1201 00, and so on. Is there an
effieicient way of doing this?