software

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.jpgplease help

MarshallYou 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:

=A1amp;quot;.jpgquot;

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

Hope this helps.

Petethanks 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

quot;Pete_UKquot; wrote:

gt; You can use a helper column to do this. Assuming your data is in column
gt; A, in another blank column you can enter this formula in cell 1:
gt;
gt; =A1amp;quot;.jpgquot;
gt;
gt; Then copy this formula all the way down to the bottom of your data.
gt; Highlight all the cells with this formula in and click lt;copygt;, then
gt; position the cursor on cell A1 and Edit | Paste Special | Values
gt; (check) OK then lt;Escgt;. You can now delete your helper column.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

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

quot;Pete_UKquot; wrote:

gt; You can use a helper column to do this. Assuming your data is in column
gt; A, in another blank column you can enter this formula in cell 1:
gt;
gt; =A1amp;quot;.jpgquot;
gt;
gt; Then copy this formula all the way down to the bottom of your data.
gt; Highlight all the cells with this formula in and click lt;copygt;, then
gt; position the cursor on cell A1 and Edit | Paste Special | Values
gt; (check) OK then lt;Escgt;. You can now delete your helper column.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;

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.

Petehi, 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

quot;Morefeus Directquot; wrote:

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

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 endplease help

quot;Morefeus Directquot; wrote:

gt; hi, pete this is a totaly different question, since you have helped before
gt; i'd like to run this by you, i have a folder with 10000 .jpg file in it that
gt; have this formate, 1234hgt.jpg its a thumb nail picture file, i need to
gt; change it to 1234hgt_thumb but when i rename them they have numbers on the
gt; end like this 1234hgt.jpg (1) and (2) and so on so how do i rename these
gt; files with out geting these numbers on the end .
gt;
gt; Help
gt;
gt; quot;Morefeus Directquot; wrote:
gt;
gt; gt; hi, i'm working with a microsoft exel worksheet columns, and i have in these
gt; gt; columns data that looks like this ( ABCDE123B16 ) 1 thru 10,000 all the
gt; gt; way down. my Question is how do i add an extexsion to the end of this data ?
gt; gt; the extension is ( .jpg ) so it will look like this ( ABCDE123B16.jpg
gt; gt;
gt; gt;
gt; gt; please help
gt; gt;
gt; gt; Marshall
gt; gt;

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