hi everyone,
does anyone know how i can replace a number with something else in a column
ex:
i have 00994455 in a column and i want to replace the first 0 with a ' . anyone know how i can do that. i have 900 numbers in the column so i dont want to do it manually.
your help is greatly appreciated

 

how about Excel's concatenate

so add 900 columns of ' (click and drag) then concatenate the two columns to make one (it joins them together)

 

If you numbers are consecutive all you need to do is change the first cell. click in the first cell and the little square on the bottom right, double click it and it should change all the numbers going down.

 

and then you could do an edit find replace to get rid of the first 0

ie find '0 replace with '

 

dave he wants to add ' - not too sure what you mean by click and drag - sure a click and drag would give him
1
2
3
4
but i don't see how that would add the '

also if you want the ' to show up you need to type it like this '' and one ' will show up

 

you're right if he starts with '' (two singles) it will drag if the numbers are consective however he still needs to get rid of an extra zero

 

dont ask me rose answered that i no know excel


bus she did do it on my laptop b4 responding so i know what she typed works

 

my way will work - just tested

the edit find replace will remove the extra zero and add the '

one thing once you're done copy and past special so the colum is text

if you want to e-mail it to me i can do it in 30 seconds

 

i excel

 

thank you for your help everyone,
maybe i should clarify a little,
the numbers are not the same so i cant do the drag thing
the numbers have a lot of zeros in them so i cant do the replace and find option.