software

Hello,

I was wondering if there was a quot;functionquot; 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 quot;.jpgquot; after the image number to an entire
column.

I have almost 10,000 rows in the column with numbers that need quot;.jpgquot;
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: www.excelforum.com/member.php...oamp;userid=31343
View this thread: www.excelforum.com/showthread...hreadid=510326
You can use a formula in another column, e.g. in B1

=A1amp;quot;.jpgquot;

and copy down column

You can then copy this column and use

Edit gt; Paste Special gt; Values to copy over your original data in column
A--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=510326
That worked! Thanks so much!--
bjkralik
------------------------------------------------------------------------
bjkralik's Profile: www.excelforum.com/member.php...oamp;userid=31343
View this thread: www.excelforum.com/showthread...hreadid=510326