Excel file

J

jazzym31

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?
 
J

Jason-K

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"
 
R

RagDyeR

You can try a custom format of:

#### ##

OR

0000 00

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


in message 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?
 
D

Duke Carey

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)
 
J

Jason-K

*rubs his hands* Oooooh...saves me from typing "concatenate" and getting
that error when I type it incorrectly...

tack!
 
Top