how to add word to the end of every word in all rows automatica

[Madirish]

I had 1000+ product code in all the rows and now I would like to add a symbol ".jpg" to the end of every product code of all rows. Example: The initial product code I had is "LLF64574F" and now I would like to make it to "LLF64574F.jpg" All the rows contain of different product code and I just want to add a .jpg in front of evey product code. I would like to know how to do this HELP.

[MarvinP]

Hello Madirish,

If your text that needs the ".jpg" in all in column G then go to a blank column on row 2 do this formula

Please Login or Register  to view this content.

copy this down for all the rows.
Copy and paste VALUES ONLY over the top of your column G.

Easy Peasy.

[Madirish]

Ok in column 1 it looks like (Below) Column 2 I coped your code = G2 & ".jpg" in column2 like (below) then coped that and pasted it down column 2. Then I coped that. Then I went to column 1 and selected that whole column and selected paste special then i click on values. In the paste special I have other options they are option 1 (PASTE) under this option I selected values. option 2 (OPERATION)
the choices are. none - add - subtract - multiply - divide . do I need to select any of them it is already on none option 3 two box first Skip blanks Second Transpose
column 1 ------------------------------------column 2
LCF20239F -----------------------------= G2 & ".jpg
LCF20825F
LCF20934F
LCF30234F
and so on

[Madirish]

column 1
LCF20239F
LCF20825F
LCF20934F
LCF30234F
and so on

column 2
= G2 & ".jpg

[Madirish]

thanks alot

[Madirish]

Column one looks like this Now
LCF20239F
LCF20825F
LCF20832F
LCF20853F
LCF20854F
LCF20889F
LCF20895F
LCF20899F
LCF20918F
LCF20976F
LCF20982F
LCF20992F
And so on


Would like it to look like this
LCF20239F.jpg
LCF20825F.jpg
LCF20832F.jpg
LCF20853F.jpg
LCF20854F.jpg
LCF20889F.jpg
LCF20895F.jpg
LCF20899F.jpg
LCF20918F.jpg
LCF20976F.jpg
LCF20982F.jpg
LCF20992F.jpg

But I have about 1800 Product numbers so I would like to add the .jpg all at one time.

[MarvinP]

If you double click on the bottom right hand corner of the cell that the formula is in, it will go all the way to the bottom. This is assuming there are no blank rows.

Then copy this entire column with the formula and copy it. Put you cursor in the top row of the original data and click on Paste Speical Values Only and you will replace all the old values with the .jpg values.

See http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/ section
Auto-fill a series of cells with data or formulas by just double clicking