hi, i'm working with a microsoft exel worksheet columns, and i have in these
columns data that looks like this ( ABCDE123B16 ) 1 thru 10,000 all the
way down. my Question is how do i add an extexsion to the end of this data ?
the extension is ( .jpg ) so it will look like this ( ABCDE123B16.jpg


please help

Marshall

You can use a helper column to do this. Assuming your data is in column
A, in another blank column you can enter this formula in cell 1:

=A1&".jpg"

Then copy this formula all the way down to the bottom of your data.
Highlight all the cells with this formula in and click <copy, then
position the cursor on cell A1 and Edit | Paste Special | Values
(check) OK then <Esc. You can now delete your helper column.

Hope this helps.

Pete

thanks pete but i still cant get it to work, i put the formula in the C
colum but it wont let me copy all the way down in C colum.

help

Marshall

"Pete_UK" wrote:

You can use a helper column to do this. Assuming your data is in column
A, in another blank column you can enter this formula in cell 1:

=A1&".jpg"

Then copy this formula all the way down to the bottom of your data.
Highlight all the cells with this formula in and click <copy, then
position the cursor on cell A1 and Edit | Paste Special | Values
(check) OK then <Esc. You can now delete your helper column.

Hope this helps.

Pete

hi, Pete still tying to do this and i know its realy simple but i'm very new
at this , could you please give some directions that a newbe like myself can
follow, very discriptive .

thanks

"Pete_UK" wrote:

You can use a helper column to do this. Assuming your data is in column
A, in another blank column you can enter this formula in cell 1:

=A1&".jpg"

Then copy this formula all the way down to the bottom of your data.
Highlight all the cells with this formula in and click <copy, then
position the cursor on cell A1 and Edit | Paste Special | Values
(check) OK then <Esc. You can now delete your helper column.

Hope this helps.

Pete

There are many ways of copying down. With long ranges I like to use the
keyboard for a lot of the operations, as it gives more control over
positioning, but here is a very quick method if you have data in the
column to the left of the column you want to copy down (i.e. in column
B in your case).

Position the cursor on the cell with the formula in (C1). If you look
closely, you will see a small black square in the bottom right corner
of the thick border around the cell (this is called the fill handle) -
just double-click this and the formula will be copied down.

I assume that you put the formula into column C because you already
have something in column B, so this method will work. If column B is
empty, then cut and paste the formula into B1 and then double-click the
fill handle.

Hope this helps.

Pete

hi, pete this is a totaly different question, since you have helped before
i'd like to run this by you, i have a folder with 10000 .jpg file in it that
have this formate, 1234hgt.jpg its a thumb nail picture file, i need to
change it to 1234hgt_thumb but when i rename them they have numbers on the
end like this 1234hgt.jpg (1) and (2) and so on so how do i rename these
files with out geting these numbers on the end .

Help

"Morefeus Direct" wrote:

hi, i'm working with a microsoft exel worksheet columns, and i have in these
columns data that looks like this ( ABCDE123B16 ) 1 thru 10,000 all the
way down. my Question is how do i add an extexsion to the end of this data ?
the extension is ( .jpg ) so it will look like this ( ABCDE123B16.jpg


please help

Marshall

hi pete this is morefeus again sory to ask but the yesterday question was
wrong, i do have a folder with files that are all different and i need to
change them to have just the _thumb on the end maintaining the rest,
1234bern_thunb 1234mdme_thumb and so on , and i have over 10000 to do how
can i do this?
i tryed to rename but just noticed that it changed the name to all the same
with the _thumb on the end


please help

"Morefeus Direct" wrote:

hi, pete this is a totaly different question, since you have helped before
i'd like to run this by you, i have a folder with 10000 .jpg file in it that
have this formate, 1234hgt.jpg its a thumb nail picture file, i need to
change it to 1234hgt_thumb but when i rename them they have numbers on the
end like this 1234hgt.jpg (1) and (2) and so on so how do i rename these
files with out geting these numbers on the end .

Help

"Morefeus Direct" wrote:

hi, i'm working with a microsoft exel worksheet columns, and i have in these
columns data that looks like this ( ABCDE123B16 ) 1 thru 10,000 all the
way down. my Question is how do i add an extexsion to the end of this data ?
the extension is ( .jpg ) so it will look like this ( ABCDE123B16.jpg


please help

Marshall

hi Pete, try this one, i have an exel sheet with a column of about 1000
prices all the way down rainging from 15.99 to 2,000 $ each price is
differen. my question is, is there a way to take the prices 0 to $75 and add
25.00 then $76 to $150.00 and add $30.00 and so on, to these prices, all
automaticly in exel without dividing up the price groups?

thanks
Marshall