Excel file
 

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?

Excel file
 

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?

Excel file
 

You can try a custom format of:

#### ##

OR

0000 00

--

HTH,

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


" wrote
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?

Excel file
 

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?

Excel file
 

Please don't multi-post. Cross-post if you must.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

" wrote
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?

Excel file
 

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

tack!
--
//Jason


"Duke Carey" wrote:

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?