Excel file

[Guest]

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?

 

[Guest]

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"

 

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

 

[Guest]

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)

 

[David Biddulph]

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

 

[Guest]

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

tack!