Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 11
Default how do I add .jpg extension to a column

I have about 10,000 lines in 1 column that I need to place a .jpg extension to. How do I do this?

Thanks in advance,

Glowinafuse
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

use a formula in an adjacent cell:

=a1&".jpg"
drag down the column.



Glowinafuse wrote:

I have about 10,000 lines in 1 column that I need to place a .jpg
extension to. How do I do this?

Thanks in advance,

Glowinafuse

--
Glowinafuse


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with macro looping and color query function kevinm Excel Discussion (Misc queries) 10 May 26th 05 01:25 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Formula for a column comicfly Excel Discussion (Misc queries) 2 March 11th 05 12:16 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"