I HAVE AN EXCEL FILE 3 COLUMNS , WHICH I HAVE TO ADD ON THE THIRD

[Guest]

I have to add a 0 in some of the numbers that are on the third column example
K10-01 should read K010-01 so that when i put them in order by number thay
will fall in the right order. is there an easy way to do this or do i have to
go change them one by one? remember these are cd's so i have to keep each
line together all columns must correspond. please help. thank you
rosy

 

[Guest]

If "K" only appears in position one, you can
select your column
edit
find
replace

then for "find" you type K
and for "replace" you type K0

then replace all

If you don't highlight the column it will add a zero after every K in your
whole spreadsheet.

 

[Guest]

hi,
this might work for you...
=MID(C4,1,1) & "0" & MID(C4,2,5)
change to fit your data.
look up the mid function in help.
put the formula in a helper column to add the zero. you can then copy the
formula and pastespecial values in the c column to get hard numgers.

regards
FSt1

 

[Guest]

I tried this thank you, but because my information is for example KF100-01
and the ones i want to change are KF1-01 to read KF001-01 when i put the find
item it gives me all the items that start with KF1 (including the KF100-01
and it ads the 0 before the 100-01 so it reads kf0100-01 not the way i need
it to read. the cd are supposed to be numbered KF001-01-02-03 etc.
KF002-01-02-03 etc. not KF2-01 KF3-01 get the picture? i really appreciate
your help on this thank you very much it would make my life a lot
easier...thanks again

 

[Guest]

thank you for your reply , but i can't understand what to do...sorry