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!


--
bjkralik
------------------------------------------------------------------------
bjkralik's Profile: http://www.excelforum.com/member.php...o&userid=31343
View this thread: http://www.excelforum.com/showthread...hreadid=510326

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 column
A


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=510326

That worked! Thanks so much!


--
bjkralik
------------------------------------------------------------------------
bjkralik's Profile: http://www.excelforum.com/member.php...o&userid=31343
View this thread: http://www.excelforum.com/showthread...hreadid=510326