View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bjkralik
 
Posts: n/a
Default Adding text after text... Is this possible?


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