Adding text after text... Is this possible?

[bjkralik]

Hello,

I was wondering if there was a "function" that would allow you to
insert text after text in an entire colum without having to type it in
each one.

What I need to do is add ".jpg" after the image number to an entire
column.

I have almost 10,000 rows in the column with numbers that need ".jpg"
after them.

So basically here is what it would look like...

Instead of:
A
30495
32485
etc.
etc.

I need:
A
30495.jpg
32485.jpg
etc.
etc.

Hope that makes sense...

Thanks!

 

[daddylonglegs]

You can use a formula in another column, e.g. in B1

=A1&".jpg"

and copy down column

You can then copy this column and use

Edit > Paste Special > Values to copy over your original data in colum

 

[bjkralik]

That worked! Thanks so much!